To get the 1gb/min, I ran the parser app on one server (dual proc hyper threaded, 8gig ram) and SQL Server on another (same specs). Each server has...

You may also find this link useful:

database publishing wizard

You could rename the existing .bak first.

then if the new bak creates successfully, delete the one you renamed.

I have found that a much faster way of parsing large amounts xml for insertion into a table is to use XmlReader. XmlReader gives you very fast, forward only...

take a look at the classes in the System.Data.SqlClient namespace. they will likely handle most of what you want to do. In particular take a look at these...

I'm not sure what you mean by "grouping".

I suppose you could group sprocs by putting them in different schemas. For example, if you have a set of...

what do you get if you run this:

SELECT *

FROM LinkerServer1.Database1.dbo.Table1 t1 INNER JOIN

LinkerServer1.Database1.dbo.Table2 t2 ON t1.col2 = t2.col2

...

This is not a good idea. Much better is to store the pdfs on the file system, and store a path to the file in sqlserver. See this...

I don't like any of these options. I don't think you should be using different linked server names in dev/test/prod. If you do, that means you are traversing...

correct, I don't think there is a UI for this in SSMS.

How many rows in the table? the "open table" feature has problems large tables (millions of rows).

I don't think this is possible in SSMS's version of activity monitor.

If the text you are looking for is in the DDL of your objects, you can use SqlSpec to generate a chm for the db. The chm indexes all...

You should ask this in the data corruption forum:

http://www.sqlservercentral.com/forums/messages.aspx?forumid=266

can you post the DDL for targettbl? from the error message, it appears you are trying to insert a value that is too big for one of the columns.