No. A GO isn't really necessary. It just allows you to break a long script into separate batches. One way to look at it...a GO is similar to a...

If you want good advice on how to set up the system, we need lots more information. If you want a poor guess, we can do that.

Things that need...

Actually, upon re-reading, I didn't state it very correctly. Your issue is that a variable is only good for one batch or stored procedure.

This is one batch:

-- Suppression de...

When you use GO, the script changes 'scope'. Your @DB_Name is no longer declared in the new scope.

Refer to the BOL, use the Index tab, enter Variables, then select...

One last comment by me on this....don't be surprised if more software companies take on this policy. Why? If you buy their product and then return it for a...

I understand your frustration and am sorry you had an experience like that. However, you do say "they have a 30 day trial version". You also imply that you did...

You won't be able to do it at the database level. As far as the database is concerned there is only one account accessing the database.

You'll have to figure a...

One 'weird' thing about SQL Server and aliases, is that you can't use an alias in the UPDATE line.

So, "UPDATE t_remarks te" won't work, but "UPDATE t_remarks" will...

Good points Rudy. The poster is obviously in FULL or Bulk-logged mode (can't do transaction log backups in SIMPLE mode - even just using TRUNCATE_ONLY - I tried it...

#1 problem....you don't have permissions to access the databases.

Do you have a SQL Server login?

Does it have permission to access the databases?

-SQLBill

Naveed Ahmad,

You aren't going to be able to do it.......

In Case 1, you want values between "(2005-12-01) to (2005-12-31)" But your results have values from 2004 (which is not...

You say the data doesn't match....in what way does it not match?

Do you have more data in DB1 than DB2? That could be true if DB1 continues to get transactions...

Rudy,

What does 'recovery mode' have to do with the poster's question? This is what the poster asked:

When backing up a transaction log with truncate_only, is it better to backup...

When you do a backup, SQL Server adds a LSN (I think it stands for Logical Sequence Number). When you do a restore, these numbers have to match or be...

I use the native SQL Server backup commands.

-SQLBill