Dave,

If they are .NET developers, let them put the connection string into config files and assign someone to manage their production config files to change password once the config file...

Brian,

I did not do linked, I use Openrowset, which is sort of the same. I just want the simple thing: Connect to each server from the list of servers in my...

Dave,

I did all that. It did not let me to run distributed transactions between different versions.

It is running if started from SQL 2005 CTP Developer Evaluation version on...

Hello,

I can add to your puzzle:

the Create Date on Pubs and Northwind are 8/6/2000 on my servers. This is not when SQL Server was even installed, it is when Microsoft...

Tom,

It is OK, at least I will know now where to go with Unix questions 🙂

I assume you are running SQL Server 2000.

Start SQL Server Enterprise Manager (EM) from...

Hello Dave,

Did you try Application Roles?

Yelena

Tom,

Probably not much of an advice, but did you try the following:

1. There are known issues with a cluster and Anti-virus. Is your server a cluster?

http://support.microsoft.com/?id=250355

2. Use Current Activity...

Hi,

Good Article!

In my opinion cursor usage should depend on "How Often". Cursors provide an easy programming solution when the extensive row processing should be done. If something should be done...

Hello,

I also read that they recommend a page file on its own drive.

I would advise against TempDB on the system drive. I had a case recently when a TempDB on...

I would like to add that you can rename and still start SQL Server in 6.5 and 2000 and then follow sp_dropserver sp_addserver recommendations per Brian's link

With SQL server 7...

Perry,

I bet it is a good server! The similar thing happened to me 3 times with SQL Server installation and with SP3A installation on 3 different servers all of...

Theoretically ANY DTS packages could have child out-of-process processes in any DTS version if you use Execute Process task or just use xp_cmdshell. They invoke executables (.exe) programs that are out-of-process by definition.

Yelena

Steve,

thanks. This is a good approach. I use Excel and Access VBA sometimes. I can just suggest another simple way.

You can click Tools->Macro->Record New Macro. Give the new macro...

Bill, Ray :

Not really sure OSQL allows GO. The parameter description of OSQL Utility in BOL says:

......(Note that the query statement should not include GO).....

Did you try a job...

Very Good!

Were you able to figure out what was the process? Sometimes you can sort of guess looking at the user, application, database and other fields in Process Info

Yelena