David,

select * from sysdatabases

will return you a lot of info including FilePath. But this path is only for the primary file. All other file locations: for the log files,...

I thought of something else: what are the names of bad-connecting databases? I had a case when the server name contained a dash - and I had to enclose the name...

Greg,

The reason for using the Source Code control could be compliance requirement for example. Like FDA or SOx compliance. That is why I asked Harry who says he is using ClearCase...

Did you check the Event Viewer Application Log if this error was logged? In this case you can run a daily/hourly  job to read the event log and populate your...

Jeremy,

read BOL article "Using @@ERROR" It has good examples. Basically you have to create a local variable to store results of @@ERROR function RIGHT after the statement. It returns the...

Harry,

Do you have a requirement to track daily code changes as a difference in code between 2 daily files  for today and yesterday?

I would check the security, logins, users etc. Does a user who is a remote login in linked server properties have permissions in these 2 databases? What is the default...

ActiveX script task, FileSystemObject

You write WMI scripts in a notepad then name it a file with extention .vbs and you may schedule them. See Microsoft Script Repository, processes examples are at:

http://www.microsoft.com/technet/scriptcenter/scripts/os/process/default.mspx

As a...

Addition to the previous post:

The header on the table is supposed to say:

Products Released General Availability Date Mainstream Support Retired Extended Support Retired Service Pack Retired Notes

For some reason I...

Hi,

In this case I would explain to them that Model database is a System SQL Server database, not a user database. I did not have a good experience moving 7.0...

BOL article "SQL Collation Name" list SQL Collations for both SQL Server 2000 and 2005. Both articles (2000 and 2005)  don't contain this one in the list and the whole article...

While there is a list of permissions, it is recommended to change the Startup account in Enterprise manager for SQL Server 2000 and Configuration Manager in 2005. This is because...

Hi,

1. ALTER PROCEDURE is recommended because all permissions are retained.

2. DBA has to run scripts but IT support has to be notified too. But before ANYTHING has to be done...

I looked up in BOL "Fast Parse" topic and it says: " Fast parse provides a fast, simple set of routines for parsing data. Fast parse supports only the most...