Only other way I can think of is to

Create table...on [secondary]

and then insert the recs. Select into doesn't allow the 'on filegroup' option.

First off: I have no idea.

Secondly: Could a work around help? Instead of trying to schedule the jobs, could you have the DTS package call them? Then...

Read the SQL Books Online. Get a machine that you can install SQL Server on and play. Go to microsoft.com as they have some labs that you can...

You can then reattach your database on the test server.

Differences:

1. Size - The backup file may be smaller than the mdf+ldf files which will help the transfer move faster.

2....

This example has helped me in the past:

http://www.sqldts.com/default.aspx?246

We had major problems with using a Third-Party imaging software to build SQL Servers. The Transaction Coordinator for SQL Server (used when you have linked servers and are running...

I run xp_fixeddrives on all my servers and it outputs a list of free space on each drive. You could insert that into a table, or have a SQL...

Did you recently place some databases in 'offline' status?

If so, you need to open query analyzer and run

--To bring a database back online

sp_dboption @dbname = 'dbname' ...

In our shop we usually push from AS/400 to SQL and every once in a while the connection fails. We've had IBM, the network guys, the AS\400 hardware people...

My apologies on the subject line...I was so excited to see this posted in DotNetJunkies that I forgot our own Steve, Andy et.al have sent much help to the region.

Is...

Doubt this will help much:

I have 1788416 in the item count and 4330642 in the unique key count and performance is more than acceptable for my users.

The problem with Identity_Insert is it can only be set on one table in a database at a time. So if you

SET identity_insert tableA ON

then will not be...

You have to be db_owner to grant the rights, but you can give the user the right to insert without granting db_owner rights.

GRANT INSERT ON tablename

TO username (appears in...

Yes...Open Enterprise Manager. Right click on the server and choose Properties. At the bottom of the General tab, you can place a checkmark to 'Autostart SQL Server' and...

If you need performance in your database, then consider placing the data and indexes on different filegroups which are on different drive arrays or LUNs. It makes the backup/restore...