Sunshine,

Which database did you get 'sys' as a Oprhaned User against? It is an internally developed database or a vendor supported database?

Regards,

Amu,

With the option of using a SQL backup compression tool (SQL Litespeed) or using compression after taking a native backup (WinRAR or WinZip), there is a cost involved with the...

I am using WinRAR for backup compression on the database servers with disk space issues. For the most part, database backups are written to the local SQL box, and...

Native SQL Server backups also compress very well with WinRAR or 7Zip (or Winzip). You could incorporate a windows batch file to compress the backups. The backup files will...

Susane,

In response to Matt Miller's remarks, I agree. If this is a back end system for a custom application, by all means work at the application level when displaying...

Susane,

I have created a small test case for you. Hopefully it comes back with the results you are looking for. Please post back if this is what you...

I sat for (and passed) 70-444 two weeks ago. I also had 52 questions, which were multiple choice. Like the first half of the 70-431 exam.

Hope This Helps,

Marios,

What do you consider "a medium-sized SQL Server shop" to be? "DBAs" can wear an awful lot of hats. Are you the sole DBA? Are you working...

Joy,

I believe that Linked Servers are supported in SQL Server 2005 Express. I have not created a Linked Server with a SQL Server 2005 Express instance. We only...

You may have a permissions issue when attempting to connect to the Access 2007 database. You will need to verify that the SQL Server service account tied to your...

Applying SQL Server SP2 is crucial to being able to created a Linked Server to Access 2007, regardless of the Edition of SQL Server you are using (Express, Workgroup, Standard,...

I also found the same link, which also gives all of the Icons used in a Execution Plan for SQL Server 2000:

Optimizing Database Performance (SQL Server 2000)

Graphically Displaying the Execution...

I have a company issued Laptop with VPN, and a company issued Smartphone that acts as a cellular modem. As long as I have a cell phone signal, I...

Jeff,

I did not mean to cause a Tourette's like reaction!

My statement about "the basics" should have been more clear. My assumption is that a company that has made a...

If you still have access to the SQL Server 2000 database(s). You can use the SQL Server 2005 Upgrade Advisor. It will run checks against your existing SQL...