You can't change a column to add or remove the Identity property.  The table-editing function in Enterprise Manager or Management Studio may make it look easy, but in both cases...

The maintenance plan will create a new backup of all databases before deleting old backups.  Any failure in any database will kill the maintenance plan before the old files are...

If your databases aren't using simple recovery mode, you must have a regular maintenance plan that backs up transaction logs or the log files will continue to grow.  This is in addition...

If the backup log says there is a backup at 11PM that you want to find out about, one quick way would be to run sp_who2 at 11PM (or 11:01PM...

If you choose the Modify action in Management Studio for a table, show the Properties tab to find the Schema property.  You can pick a new schema from the list.

Note that in...

You may also want to include the SID field to make sure your SQL logins are sychronized.  Also exclude Windows logins (password is null) and sa (sid is 0x01).  Just...

You mention a configuration file and a configuration table, do you have multiple configurations?  You can set the same property in multiple configurations, whichever one is applied last when the...

My first reaction is that anyone asking "What are those?" (and we were all there at some point) should be chained to a Northwind or AdventureWorks database on a development...

The learning curve to migrate to SQL 2005 is not large.  Download the Upgrade Advisor from Microsoft and run it on your existing databases to see what issues you might...

NEVER do an upgrade if you can possibly avoid it (applies to SQL Server, operating systems, whatever).  Get a fresh install on a new box, migrate the data, and wipe...

The UNION approach is good if you want the result in two rows.

If having the two answer as two fields in a single row will work, use:

SELECT COUNT(product) numPol, product,...

It's hard to say what is the "best" way, but the typical way to access tables on another server from MSSQL is to define a linked server and use four-part...

Enterprise Manager can script a database into multiple files (one object per file), and you can create a project in SourceSafe with all the files.  It's a completely manual process,...

If you right-click on a package name in Enterprise Manager, one of the options is "Versions".

You can summarize the size and versions for all packages with this query:

SELECT

Not to nit-pick but CASE is a function in SQL, not a statement.  All of the THEN and ELSE clauses must evaluate to single value, and all of the values must be of...