I am pretty new to this - what references do I need?

Grants first solution will do that. will it not?

http://www.sqlservercentral.com/articles/Advanced/foreignkeys/2423/

states:

-- To check whether the FK is enabled or NOT?

SELECT OBJECTPROPERTY(object_id('myforeignkey'), 'CnstIsDisabled')

-- To check whether the...

Good call - I missed that it was 2000 - sorry!

a quick google search resulted in this site (http://blogs.technet.com/damirb/archive/2005/12/10/415892.aspx[\url]) saying:

Exporting Database Diagrams from SQL Server Management Studio

A question that arose at one of the stops on the SQL Server 2005...

Frank! That was incredibly helpful! It now works...well, it runs...however, my linebreaks are still there...

question, since I dont know for sure, but is vbLf like line feed? ...

Update - It looks like I was able to get the correct syntax:

If Row.CommentsClean.ToString.Contains(vbLf) Then

...

Frank,

Thank you for the help! I did try this, however, this is something I have never done before, and seem to have come to a couple road blocks...

First off,...

Okay - next thing I found was this:

http://support.microsoft.com/kb/201905

if these were tested, perhaps it would be better to tell us whatelse you have tried.

I am sure you found this, but wanted to point it out anyway:

http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

states:

It should be noted that the Excel file must be located in the SQL Server where you are...

Yes - we need SP 3 & 5.

Does anyone have a link or article that stats MS is not going to make SP3?

Red-gate has a nifty tool that came with my toolbelt - SQL Prompt - I used it when it first came out and free, and it was SLOWWWWWWW...but now it...

I am hoping that once enough time passes, you intend to follow up with this manager, show your results, get his answer, and most importantly, share with the rest of...

How big is your DB? I recently ran that against my 30 gig DB, and it took some time...

http://msdn2.microsoft.com/en-us/library/ms178632.aspx

states:

Switches the execution context back to the caller of the last EXECUTE AS statement.