Would one of you sql gurus please explain the difference between using a timestamp datatype and a datetime datatype - eg: I have often used a datetime datatype with a...

I second that - the column "Body" in Email_Templates needs to be of "text" datatype.

1) Use the "export data" wizard - right click on table you want exported, choose "all tasks" - "export data".

2) Select your server and database in "data source" - go...

The first thought that comes to mind is "dependencies"....are these tables dependent on any other object - stored procedures, triggers etc.. ??

What are the read/write access permissions granted to users...

You may have already looked into this but what about the checkbox for "Commit transaction on successful completion of this step" ?

Are the number of nodes unlimited or is there a ceiling ?! Also, is there a naming convention for each of these nodes (node1, node 2 etc..) - could you...

I tried explicitly specifying the columns in my test example and it doesn't work!!!

Manish - a quick "google" got me the following info that you may find useful - I don't use vb.net but I use vb 6.0 and call stored procedures all...

Manish - here's something from BOL that explains this:

***************************************

You may have included a statement in the BEGIN-END block that has side effects, which is not allowed in user-defined functions. Function...

okay - thought that's what it was - thanks for explaining!

Frank - I plead to being singularly obtuse on this one...can you please explain the *28 ??

This is the reason I start my day with sqlservercentral.com even before my ritualistic cup of tea...

I haven't had occasion to use import (for views)...so this is definitely a noteworthy...

Try this...

SELECT CAST((DATENAME(MONTH, DATE))AS CHAR(3)) +', '+ DATENAME(YEAR, DATE) AS 'MONTH' FROM TABLE

You can rename a column by editing in enterprise manager (quickest way)...however, you have to make sure...

Hear! Hear!

Steve - you've hit the nail on the head - repeatedly in fact - wish those poeople at Billy Gates' empire would sit up and take notice.

I've been...

Yes Troy - certification SHOULD (hopefully) verify existing knowledge in addition to building on knowledge-base...

Also you're right about MCP certification for a single exam...since I work with SQL design and...