Correct!

I was just refering to the syntax error issue. Good point to keep in mind about the NOT NULL, You can overcome the issue by using ISNULL function 

DECLARE @SqlCmd NVARCHAR(4000),

       ...

Are you using AD ?

if Yes create a linked server and then interrogate it :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

If no

Then run:

create table #t1 (data varchar(255))

insert into #t1 exec master..xp_cmdshell 'net user'

select  --...

OK all that's fine if you don't pass parameters. If you do you will need dynamic SQL because Linked server do not accept variables in their execution commands.

Cheers,

Erik,

Your SECOND ROLLBACK is always executed regardless of the path that the code took before!

I suggest you indent you code to get a better Idea of what's going on

Cheers,

if you have the Backup available and a spare system there is nothing preventing you from start that restore NOW!

That restore process is only as fast as the hardware...

When writing Dynamic SQL you have two choices to avoid those problems:

1) Do not break the string into several lines

2) If you must break it use explicit CRLF Terminator at...

If your backups are standard SQL Backups and you are not using third party tools the anwser "unfortunately" is NO, There is NO WAY.

Now, if you are using third party...

OR

-> Use an output parameter in your proc!

SQL Server 2000 does not store data in UTF-8. Mainly because it uses Windows collations for unicode data which are based in two bytes per character (UCS-2 and UTF-16)

For more...

Although the article is well written  and many of us have used this sort of techniques in one way or another we should not be blinded by its drawbacks.

1.The use...

3) Into which System table does enteries are maintained of who have successfully logged IN and who were failed to Logged IN

You can create alerts for successful and...

Correct!

What does the following statement returns on the rebuilt Server?:

select serverproperty('Productlevel') lvl, serverproperty('ProductVersion') ver 

Yeah sometimes I like to guess a bit

Just cast them explicitly to int. like:

 if (Cast (@currentBid - @NewBid as int) % Cast(@bidincrement as int)) = 0