Viewing 15 posts - 1 through 15 (of 237 total)
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...
October 8, 2003 at 4:32 pm
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.
October 6, 2003 at 10:57 am
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...
October 3, 2003 at 5:10 pm
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...
October 3, 2003 at 2:30 pm
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...
October 3, 2003 at 12:27 pm
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...
October 3, 2003 at 12:06 pm
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...
October 3, 2003 at 11:53 am
Mark, thank you. It helped.
Edited by - mromm on 09/11/2003 5:33:19 PM
September 11, 2003 at 4:34 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...
September 10, 2003 at 11:02 am
The AVG function will ignore NULL values in its calculation and provide a warning that NULL value is eliminated. You could test it easily.
September 10, 2003 at 10:54 am
Thank you Steve.
September 8, 2003 at 5:27 pm
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...
July 30, 2003 at 1:22 pm
But how do I figure out if seed and increment were specified explicitly or not?
CREATE TABLE tbl_1 ( col_1 INT IDENTITY )
CREATE TABLE tbl_1 ( col_1 INT IDENTITY( 1,...
July 29, 2003 at 2:54 pm
Never mind, found it. It is IDENT_SEED( 'table_name' )
July 29, 2003 at 2:44 pm
Yes, they join on ID. What is the exact query you have created?
July 29, 2003 at 2:30 pm