I have to admit that I was quite pleased to find myself "promoted" to Forum Guru, having formerly been a Junior Subamateur Forum Stalker, or something like that.  I'm considering...

Error 3604 is an oddball, at least on my server, because it does not set @@ERROR, even though the severity level of the message is 16.  There is no way...

Your code has the snippet:

3/ While @@FETCH_STATUS <> 0 

Don't you mean WHILE @@FETCH_STATUS = 0?  A zero means that the fetch worked.

While...

Cloning a database is easy in SQL Server.  Really.  In fact, it looks like you've already succeeded.  The problem is in the master database, but restoring the master database is...

As Frank says, you should look up triggers in the BOL.  The INSTEAD OF trigger is probably the most elegant way to handle this, but you can do this with...

I agree with Jonathan that you should be using DATETIME or SMALLDATETIME as your datatype.  But if you really want to stick with char/varchar, then you should use CONVERT instead...

I'm not sure your request quite makes sense to us yet.

You can't input values into identity columns (unless you set identity_insert on for that table) - they are generated by...

It could be that what reddyk needs is the ability to receive a comma-delimited string of arguments and parse out the individual arguments, or something similar.  If so, the following...

I was hoping to be able to put together a script for you, but I am not going to have the time.  In principle, all you need to do is...

Do you just want the server definitions and settings, or do you want all the associated remote logins as well?

1. Is it feasible to combine all 17 language columns in a single table? This is preferred from a development perspective, as change/revision control simplified- as is the development of...

When you say that the log is 4Gb in size, but there is about 500 Mb in use, do you mean that you are looking at the output of DBCC...

Kenneth,

You are correct, but surely SQLBill is on the right track here - just because you can ping the server doesn't mean that TCP 1433 (or whatever non-default port...

With such a generic post, I don't think you'll get many responses, so I thought I'd at least send you a URL.  You can find some sample code and tutorial...

One more thing, ccundy, although you probably already know this ...

You shouldn't code DISTINCT in your subquery when it is being accessed with a set operator like IN, EXISTS, ANY,...