--Make @C a varchar as in the following:

declare @gcASCII char(300), @a CHAR(10), @b-2 char(10), @char CHAR(1), @C varchar(10)

DECLARE @counter int, @len int,...

Do you know T-SQL at all? We aren't going to do your work for you. If you need help with certain aspects of T-SQL or patterns the forum is a...

...but, you need to be aware, that because of O/S restrictions, the .exe can not be over 4GB..... so if your (compressed) backup file is over that, forget about the...

HeH - well the important thing is that you have a solution. I am glad you found it and it did seem a little wrong to be debating over something...

I hope it helps your environemnt Steve. And thanks for the clarification on the versions that allowed the lock pages Perry. I always felt resentful that the SQL engine would...

Replication is more secure because it is managed, automated, and you can use an active...

Why can't you at least use pass through security via Kerberos instead of supplying username and password in cleartext. This way you wouldn't have to create a separate linked server...

Sounds like the story had a happy ending and at least you guys were "chasing his tail" and not your own. Even if you did "trip" over the solution you...

My sincere advice to you is abandon linked server. It poses a security threat and it's only use is to circumvent doing it the right way by doing it the...

Yes, you need to generate a new snapshot if you add an article to a publication.

However, you could add a new publication (it doesn't matter if it's on the same...

I would not do what you are doing with your multiple instances. I would generally opt for one or two instances and share resources. However, I assume you have good...

I use Quest's Spotlight which can send alerts and capture history related to several metrics including deadlocks. However, you could also just add an additional server side trace to capture...

Are you executing the exe on the Server that you are restoring to - if not try that.

Your sentence structure makes it hard to understand what your issue is. If the job is still running when the schedule would be set to fire then the schedule will...

Redgate and quest also provide object level restores with their backup solutions. Additionally Quest offers the ability to save a backup as a self extracting .exe file that can be...