Would you alwys find "PPS" and "PAGES" on all your strings ?

did you try:

exec sp_removedbreplication

right after the restore ?

shensarling (7/10/2008)

---

Thanks for the reply Steve.

We have decided to set the Recovery Model of the database to Bulk-logged and then drop and recreate the index. After creating the index...

PollingInterval too small is bad for the publisher as well as ReadBatchSize too big.

I would recomend you start with the defaults and only if you think is not good...

You can use logon_triggers to limit your exposure and to log the IPs from where the attempts were made.

The purpose of TSQL is to encourage SET-BASED processing and not a row-by-row processing. Can't you do what you need to do on all affected records at once ?

If you...

I am not sure you want to return all the data in one go. Usually people add nodes as the are "expanded" and the child(S) are empty. The reason is...

Heh... There is a saying ... you can learn something new every day. I wasn't aware that "insert exec restriction" was removed in 2005.

INSERT INTO ... EXEC does *not* works with table variables, try with TEMPORARY Tables (#) instead.

your server could also be under too much parallel activity.

Some functions return sql_variant datatype like SESSIONPROPERTY and you many not want to perform conversions on the output so you use sql_variant to store the results.

You should run UPDATE STATISTICS tblname WITH FULLSCAN on all your tables and try to rebuild all indexes.

Matthew Cushing (7/7/2008)

---

I'm trying to run a script that will put two keys onto a db. So far no problem. But when I go to look at the...

DBASkippack (7/7/2008)

---

Trying to attach a DB that contains partitoned tables - receiving error msg:

Database cannot be started in this edition of SQL Server 2005 because it contains a partition...

Maybe something like this :

DECLARE @T TABLE ( dt datetime, In_Averagebps decimal (9,2),Out_Averagebps decimal (9,2) )

INSERT INTO @T (dt,In_Averagebps,Out_Averagebps ) VALUES ('6/16/08 6:01 AM',135151.9,141747.9)

INSERT INTO @T (dt,In_Averagebps,Out_Averagebps )...