In BOL Index tab, type the key word "SET XACT_ABORT".

From BOL:

"When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled...

In a nested transaction, the rollback command in any nested SP will rollback the whole transaction and the @@TRANCOUNT will jump to 0. This is the expected behaviour of SQL...

Here is the contradiction. For linked server, th SP needs to set XACT_ABORT ON. It means the SP will rollback and termidate immediately if run time errors happen. The application...

Ok. I don't know xp_cmdshell is disallowed in your environment.

If the query in th text field is >4000chars, sp_execsql does not work. However, you can concatenate multiple 8000bytes string and...

Both VS and SQL server 2k5 have beta version released. What about download from MS site now instead of waiting?

When turing HT on, I experienced performance degradation in w2000 with SQL 2000 enterprise edition. So my suggestion is on W2000, turn it OFF.

On W2003, windows has better support for...

Lots of reasons, such as security, server load, differeent administration tasks etc.

It's not recommended to do this. But in a small organization with 10 PCs, why not? Budget has the last...

It depends on lots of factors, such as down time, server load, table size etc.

Defrag is online operation has samll impact on other transactions. Reindex one table is one big transaction and...

Firstly, if country, State, City, ... hierarchy is not avaible, you can has a list of buttons of letters "A", "B", "C", "D",...."Z".

Second, it's better to implement paging in the server...

It's true. Every technology or solution has its pros and cons.

If you use this feature in Sybase, it means you need to manage related dbs as a group.

A gun...

Check @@error first after you make the call.

If no error and @@TRANCOUNT>0, commit it and you can get the value of @return.

If @@error<>0 and @@TRANCOUNT>0, roll it back. In this...

If the new server only hosts your db, the simplest way is to reinstall SQL server and resttach ur db.

Anotther solution is query the text field to a file and then run it in my previous suggested way.

To query the result to a file:

 DECLARE @Command nvarchar(255)

 DECLARE @ServerName nvarchar(255)

 SELECT @ServerName=CAST(SERVERPROPERTY('servername')...

Sorry, I read the question as query stored in text file instead of text field. The above mentioned solution does not work for text field.

If you know the possible maximum...

If you do not care about the context, you can pass the file name as a parameter in your SP and call isql to run it.

CREATE PROCEDURE dbo.usp_RunScript @ScriptFile nvarchar(255)

AS

 DECLARE...