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...

smknox (12/29/2007)

---

how can I modify usp_Prognote_Insert to return the value of the PK if a record already exists?

This doesn't seem to work:

CREATE PROCEDURE usp_ProgNote_Insert

@SecondaryKeyValue int

,...

They are just icons for the maintenance plan. They have no special meaning.

The difference can be explained by looking at the version of SQL Server you are connecting to....

SQLIS has plenty of examples for all types of transformations. You might want to take a look at the rowcount transformation examples.

Sure, what you have is:

,'TeamMentor' =

CASE

WHEN TeamMentorDate IS NOT NULL THEN 'Team Mentor'

WHEN (SELECT r.AchieveTitle FROM Repromotes r WHERE RepFlag = 'X' AND AchieveTitle = 'Team Mentor) THEN 'Team...

Yes - you can, but I am not sure you need this. Anyways, for that part - you can use an EXISTS, or check for NOT NULL. Examples:

CASE

...

Plenty of options and help at: http://www.sqlis.com

SQL Server uses the Windows password policy mechanism. So, whatever is defined on your server (Windows 2003 or higher) is what will be used.