Please save your stored procedure source code in files as you type those the first time. Then store those files of SP source code in a safe place (say, version...

Ravi, to avoid loosing your objects, encripted or not, store the source code of all objects in text files, preferably with some version control software.

Michael

Why not do a backup of your DEV and restore on TST and STG. This would be much faster then DTS and assure the absolute equivalence of the databases including...

I tried to force the server to utilize more memory by creating a table variable and feeding it with the huge amount of data. It had no affect on the...

You can do it by utilizing string functions of SQL Server including REPLACE, ASC, CHAR, etc. But the code will be... not pretty and slow. It makes sense to consider...

You can use WITH ENCRYPTION option with stored procedures, user-defined functions, triggers and views alike. Those store their source code is syscomments table. If you specify WITH ENCRYPTION, syscomments does...

You have several options. The first one is to use SQL Profiler. Create a new trace, set appropriate filters (including ObjectName to the name of the table desired). The second...

Mark, thank you. It helped.

Michael

Edited by - mromm on 09/11/2003 5:33:19 PM

When you have an INSERT trigger on table A, it deals with as many rows as many were inserted into your table A by a single INSERT statement. All those...

The AVG function will ignore NULL values in its calculation and provide a warning that NULL value is eliminated. You could test it easily.

Thank you Steve.

Michael

A better SQL syntax for your query shoyuld be as here:

select o.name, i.name

from sysindexes i

join sysobjects o

on i.name like '_WA_Sys%'

and o.id = i.id

However, why are you checking...

But how do I figure out if seed and increment were specified explicitly or not?

For example,

CREATE TABLE tbl_1 ( col_1 INT IDENTITY )

versus

CREATE TABLE tbl_1 ( col_1 INT IDENTITY( 1,...

Never mind, found it. It is IDENT_SEED( 'table_name' )

Thanks.

Yes, they join on ID. What is the exact query you have created?