There are multiple ways of doing this ....

1) Simple Null check in the where clause

2) Dynamic SQL

Since the query in question is not so huge i guess we can...

Hi Deb,

I was getting NULL for some of the tables when i ran the script on my DB. But when i tried this

ISNULL( (SELECT rows FROM sqldev.workshop.dbo.sysindexes               ...

I assume you are talking about writing some details to a text file. Try this ...this is from BOL.

E. Write variable contents to a file

This example writes the contents...

Sorry a Heap is a table without a CLUSTERED Index. missed that important detail.

Cheers!

1. SysIndexes system table will contain the number of rows for each table in the db. Existence of indexes is not a factor.

rows will be populated against the row with...

Our application sends about 15 - 20 k emails each day and it does it pretty smoothly ...Not many glitches

We have a...

As Brian and Tony pointed out, try disabling this constraint before deleting the records. Another way maybe to delete the records in batches of say 500 or 1000. Check it...

I dont think you can export ERWIN schema diagrams to Word either...or can you??

Cheers!

Well I really dont know how expensive the other products are....But i used the evaluation copy of SQL Compare form RED GATE and really liked it. And subsequently bought it...

Thats really cool Debjit.

Dave - Thx for the excellent suggestion...Never thot abt using the rows from sysindexes...

Out of curiosity...i am sure this will work fine for tables with clustered...

I have just written a simple piece of code which suffices the purpose specified by you...you can enhance it if u need it to do more ...It takes less than...

I am not sure there is much that you can do here unless you have some kinda logic that compares the previous value with the next one. In which case...

Thx for the quick response both of you. Good one mike.....I totally lost my plot today and needed some help desperately.

Cheers m8!

As earlier pointed out by DB,

SELECT spid ,status ,sid ,hostname ,program_name ,cmd ,cpu ,physical_io ,blocked

 ,dbid ,convert(sysname, rtrim(loginame)) as loginname ,spid as 'spid_sort', substring( convert(varchar,last_batch,111) ,6  ,5 ) + ' ' + substring( convert(varchar,last_batch,113) ,13 ,8 ) as 'last_batch_char' from

master.dbo.sysprocesses 

The loginname column would give...

Schleep,

I agree with you there....its recommended to use temp tables rather than table variables when the expected size of data that will be stored is huge...but it also depends on...