Ivan,

Si batallas con el inglés te puedo ayudar a traducir, aunque no puedo ayudarte con ese error.

Everyone else,

I can help with translation, but I'm not sure what's the error.

Translation for...

Why is everyone so upset about the answer? It's clear that the question is if you can restore the database without deleting the other snapshots. Otherwise you wouldn't have multiple...

There are plenty of ways, the...

You could solve this with Dynamic code or by writing different queries trough a condition (IF...ELSE...).

I'm not sure if that is what you need.

You must do the sum before you cast your values.

SELECT id,

nm,

CAST(REPLICATE(' ',16-LEN(SUM(AMT*1000))) + CONVERT(varchar(32),SUM(AMT*1000))...

Taken from BOL http://msdn.microsoft.com/en-us/library/ms188029.aspx

"You cannot create new_table on a remote server..."

Have you tried this?

select top 5 *

into [this.that].dbo.ztb_test

from zt_sysjobs

Is this the right place to demonstrate how good is greater than evil, just by using SQL?

It's hard to know if you don't give the exact error, code and/or...

One tip I could give you is to use the debugger to check you have the correct value in the sSQL variable.

The other thing I noticed is you wrote the...

This is a repeated post and was solved in here

http://www.sqlservercentral.com/Forums/Topic1329746-392-1.aspx

By the way, I made the same mistake as Stewart

To start with the suggestions, you can always use:

SELECT @@VERSION

to define the version of SQL Server you're working with.

In the other hand, bitwise operators will return an integer (the result...

IMHO the best way is to create a carriers table with the information needed and add a field column (Insert Celko's quote saying "columns are not fields":-D) for a...

How do you know if you should use @txt.att or @messaging.sprintpcs.com or something else?

You're right, I got confused with the term as I haven't used it in a long time.