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.

midan1 (12/22/2007)

---

hi

i ask the friends here if thay can help only !

i am working on complex project and i need it

to find the "day before Last day of...

With your SAN an HP EVA - single disk group with 120 spindles, it won't make any difference at all. All LUN's are presented from the same set of...

I would be very concerned about this approach, since you no longer have any way of restoring your system to a point in time prior to your latest backup.

Take this...