Does it mean you will have the same SA password on all boxes? This will be a bigger security concern than older passwords. Moreover, more people will need to know this...

Yes it is.

I normally create stored procedures in SQL Server or if I have a job in SQL Server, I would refer to sp_start_job

http://msdn2.microsoft.com/en-us/library/ms186757.aspx

Then from Microsoft Access I use...

Could we just have a function that will add all non-null values? Something like VSUM where V stays for value?

Hi, BOL Article Using Files and Filegroups says:

"Filegroups use a proportional fill strategy across all the files within each filegroup. As data is written to the filegroup, the database engine...

Also check the data, are they really the same? There could be leading or trailing spaces.

Where in the reference it says "in clear text" ?

Linked tables return the sorted view, I tested. How do you use ADP? are you talkig about ADP functions? We found out that in Access 2003 ADP functions don't really...

This will log the result of RESTORE HEADERONLY to a table. The backup size is one of the fileds. You can use it in a loop for all files in...

I tried to get a definition of sys.sysusers view by selecting:

SELECT

OBJECT_DEFINITION(OBJECT_ID('sys.sysusers'))

I got a definition, but the FROM list includes tables like sys.sysowners....

Hi,

SQL Sever Views can not be sorted (include ORDER BY) unles TOP is specified too. It was the same way in 2000 too. Please, give an example of what you...

Paul,

This is under Client Configuration (a button) in Administrative Tools ->Data Sources and then selecting your data source under File DSN.

Client configuration points to the same Client Network Utility as...

Check if the firewall is open on port 1434 to browse between instances or configure DSN not to use "Dynamically determine port" I also will ask our Citrix admin who...

One enhancement that is done by SP2 is allowing to create maintenance plans without using Integration Services. Maybe the change messed something up. I did not test it  yet.

A couple...

Paul,

The most possible reason will be that some logins on the new server have different SIDs from the old server even if they have the same name. Make sure you can...

Then I would keep track of the number of databases in a table. Then run a job once a day that compares the result from select count(*) from sysdatabases to...