you'll want to compare that column against the current datetime, which you get from the built in GETDATE() function.

you also want to use the DATEDIFF function to return minutes():

ie:

SELECT *...

hope this helps: i created a linked server via script, then screenshotted the results in the GUI. You said you can create one via script, so you can do the...

the new 2008 booksonline has a lot of stuff on MERGE and EXCEPT

http://technet.microsoft.com/en-us/library/bb510625.aspx

the neat thing is how it has clauses for WHEN MATCHED and NOT MATCHED:, when the merge finds...

SQl Recon is a free tool that is much more robust than any vbscript you might use; it will find SQL instances you may not be aware of.

it can provide...

I don't know about you, but If I'm trying to learn something new, I only seem to benefit from watching a video, and then doing lab-type exercises to practice what...

well if you are doing this to improve your understanding of how SQL works, I applaud you; sometimes reinventing the wheel can be a very rewarding experience education wise.

practically speaking,...

I would do the same as Chirag suggests, database by database, I'd detach the mdf/ldf, physically move them to the new drive, then reattach;

after that , i would review the...

don't know if it helps, but when i went to install SQL 2008, I had to upgrade my existing Visual Studio 2008 to SP1 before it would allow itself to...

the forum doesn't like things that look like html tags....wierd results occur, like the clickable button above, which got rendered as an object instead of text:

i had to find and...

I googled for the specific error you said you are getting, and couldn't find anything specific;one post said they simply stopped and started their SQL service and agent, adn that...

just looking for confirmation...i used my google-fu and found info and examples for using hashbytes with SHA1, ie

select HASHBYTES('SHA1','My Plain Text')

--results

0x6D99DDF6FE7A32547B6766E0BF88B1F50835F0FF

everything i read says that this is a one way...

too many variables; show us your current vbscripts, and we can offer suggestions. most likely, it's nothing more than reading recordset values into some local vbscript variables, and writing...

i guess your vbscripts are creating a connection and querying each server, right?

there's an excellent MS article on this kind of info:

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

vasically it suggests this as the query:

SELECT SERVERPROPERTY('productversion'),...

i ran this test below...he's right...if you had a column defined as char(200), for example, stuck data in it, then changed the column to varchar(200), the datalength is still 200...even...

Adi I read the requirement as he alreyad changed the columns from char to varchar, and now wanted to remove trailing spaces:

Note, the length of the data type should not...