One thing you also should be aware of is that you always have the option of executing a SQL Task in your maintenance plan.

So, you don't have to use the...

Sorry - the command should be:

Use [db1]; Execute sp_updatestats;

Use [db2]; Execute sp_updatestats;

...

Just one other note: In SQL Server 2005 the system stored procedure 'sp_updatestats' has been improved to only update statistics on tables that have been modified.

If you use the maintenance...

John Morris (2/3/2008)

---

jeff.williams3188 (2/3/2008)

---

Another option is to download a trial version of SQL Compare (www.red-gate.com) and SQL Data Compare.

Build a comparison project between your two databases using SQL Compare, select...

You can also use variables in the CTE:

DECLARE @myVAR int;

SET @myVAR = 1;

;WITH myCTE (col1)

AS (SELECT col1 FROM myTABLE WHERE col2 = @myVAR)

SELECT * FROM myCTE;

Another option is to download a trial version of SQL Compare (www.red-gate.com) and SQL Data Compare.

Build a comparison project between your two databases using SQL Compare, select only those objects...

I know you stated you did not want to use third party tools, but I am assuming that is because of cost. So, visit http://www.quest.com and download...

There is an option to repair minor errors. If that option is checked - then exclusive access is required to run the integrity check.

Generally, you do not want the...

A couple of ways to find out:

Open Activity Monitor, find the process and see what commands are being run.

Or, install the Performance Dashboard Reports from Microsoft. Run the report...

239 columns? You definitely have a problem with normalization. I would highly recommend normalizing this table.

The only reason I could see having this many columns (and this is...

If you cannot afford any downtime, the only option is to backup/restore. Now, since you will be moving your backup files to a network share (make sure you have...

Since they only need something to run queries - there are several low cost (and free) utilities available.

I prefer either Toad from Quest or DbVisualizer, but there is also WinSQL...

I have no idea how many apps would run - all I know is that one of my vendors would not support the version we had on SQL Server 2005....

This sounds like a vendor supplied application. If so, and the vendor does not support this version on SQL Server 2005 - there are no options for you other...

Take a look at the SQL Compare and SQL Data Compare tools from Redgate. I hope they are making these changes on a test system first. You can...