Developer Newsgroups: SQL Server Tools

Different link

jim.steiner - 16 Mar 2007 6:48 PM - 3 messages

Thanks, but this is the link I went to listed above. It does not explicitly say you can install the tools on a client box without a license if you have a server license. You can infer that from what it ...

varcharmax issue

DWC - 15 Mar 2007 6:55 PM - 4 messages

I ran into an issue with varcharmax and I was wondering if anyone knows about this If you look at a file exported from sql mgmt studio it exports the line in the create statement for a varcharmax field as ...

How to set SQL Profiler via command line

MS - 15 Mar 2007 8:29 AM - 4 messages

Hello, How can I set SQL Profiler to capture the logs via command line? I wanted to this just before my testing. This is what I have: I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I ...

Link needed for free client tool install

jim.steiner - 14 Mar 2007 8:31 PM - 2 messages

My customer wants to install the client tools on his local box to support the SQL Server Standard 2005 license he has on his server. the tools on any supporting box he needs to. I would link to a ...

SQL Server Profiler

clintmazur - 14 Mar 2007 3:25 PM - 3 messages

When I try and start a trace I'm getting the following error: Una ble to read trace definition file Microsoft SQL Server TraceDefinition 8.0.0.xml. Click OK to retrieve it from server. Retrieval may take a few ...

Recovery Model Question.

Cipher - 14 Mar 2007 3:01 PM - 11 messages

Hello to everyone, I want to ask if there is a way ,maybe through a strored procedure or sql script to change massive in 200 databases for example the recovery model from full to simple ?? If anybody has an idea or knows i will appreciate it. ...

2005 selected databas monitoring - how?

Sergejs Degtjars - 13 Mar 2007 11:31 AM - 5 messages

I have three databases with same user login. How can I monitor activity only for one database (logins, transactions) in SQL 2005 server? I can't change the user for this database. ...

SQL Server Agent - Job Documenter

tinku_bmcl - 12 Mar 2007 11:07 PM - 1 message

I am in need of a tool which can document all the databases, DTS and SQL Server Agent Jobs. I know about documenter tools for databases and DTS. Is there documenter tool for SQL Server Agent Job? ...

SQL Agent Activex script jobs in 2005

Tony_L - 12 Mar 2007 12:59 PM - 1 message

Hi, I'm transferring various jobs over from SQL Server 2000 to a 2005(SP2) server.The jobs are written in VBScript and SQL DMO. Everything works fine except for the print statement. Where i used the print statement in 2000, the ...

A good Database Modelling Tool for Sql Server 2005

WoodenSWord - 12 Mar 2007 12:19 PM - 5 messages

Hello i am looking for a good database modelling tool in order to design an sql server database. I have recently come across with DBDesigner 4. Can you suggest me a better alternative? ...