Sergiy is right why do u need #ins. BTW what about existing data ?

Hi

This is what CTE's are there for in sql2005 - recursive querying. check out BOL for details on how to use CTE in case you dont know.

How ever CTE's...

Hi

Yes using a SP would be the right approach in this case. you can return multiple recordsets in a sp.

Since you are dealing with large number of records make sure...

Hi

How did you port your sql2000 db to sql 2005.

are the statistics and indexes updated.

Also check connection settings from the middle tier.

If you have a test server you can upgrade...

Hi

As Jeff said have a integer identity column. have another column which tells which "type" of body it is. even this column can be numeric.

ex:- 1 = Ministries...

Hi

Did not understand you clearly but still...

If you want to look whether a particular column allows nulls you can query the sys.columns or information_schema.columns views. Both these views have the...

Hi

Must confess dont know much about this one. Just searching got me this info abt this counter -SQLServer:Database Mirroring . May be you could use the other counters to measure...

Hi

Error message says "invalid connection string". Check the connection relate things , user accounts under which the 2 instances are running etc..

Hi

There are different ways of doing this. Some of them are

1) Backup - Restore

2) Attach

3) Script the db, run the script in the other server and port the data.

I would...

Hi

BOL means Books Online. Press F1 from management studio to get the help where you can search for DDL Triggers.

Check out some sites, get a basic idea of things.

Hi

Better use a transaction (client side). Otherwise the mail may not be sent but the status will be updated.

Hi

i dont think we can avoid a loop in this case. However you can use a while loop instead of a cursor. Try and avoid cursors as much as possible.

Hi

I think u can use the pivot operator for this. search this other sites for how to use pivot.

Hi

Thanks

Hi

This sample statement will generate the concatenated values for id = 12.

Declare @abc varchar(100)

SET @abc = ''

SELECT @abc = @abc + Text from table1 where id = 12.

select @abc.

you can...