Thanks a lot.

Hi I do not currently have access to a SQL 2008 server. I would love it if someone who has SQL 2008 checks the code to see if it works...

My 2 bits are as follows

1. Use views/tables

2. Join using the So Called database expert

3. Decide what your rows will be...

Check the LogOn account under which the 'SQL Server Agent' service is running. Make sure its a DomainUser(If using AD) who has previliges on both servers. The default user account...

drop the convert(datetime from the code and run. See what filter condition needs to be added to the case/where,(it has to be one or more records in your table of...

Maybe this will help. The AsOfDateTime column will return nulls if its an invalid date. Ofcourse if all you want is the datetime and not the other columns in the...

As mentioned its for parsing Parameters passed in to a stored proc. In a real world scenerio an app would let a user select multiple items in a list, most...

Sweet bit of TSQL code. As stated by Amit, he used this to parse out parameters passed into a stored proc, so practically the number of params normally would not...

Hi

Back in 2008 I posted a similar script 'Find Mismatched Views and Stored Procs' (http://www.sqlservercentral.com/scripts/Development/63270/), given 2 databases it lists out the mismatched Views and stored Procs....

I posted something similar some time ago. Please do check it out and give me your opinion. The physical file check is something I am not doing in my script...

Hi,

Try this instead, works just as well. Basically I insert a space between the Date and the time and a : between the hours and the minutes

declare @DtStr varchar(20)

set @DtStr='200907011020'

select...

:ermm:

Sorry the pasting of code did not seem to work too well, I am trying to attach the code within the IFCode Shortcuts, hope it works

SET @tableHTML =

N''+

N'.h1...

Normally in production the number of days since last backup should all be 0 as the backups are critical. However should you need the number of days just change the...

I myself prefer using Visual Source Safe. I use this for my StoredProcs on my dev box. For mismatches between the DevBox and the Staging servers I use a stored...

Robert Davis (5/22/2009)

---

That's great if you only have one or two SQL Servers. Would you do the same if you have 30 servers or 300 servers or 3000 servers?

I think...