As stated above, no you can't attach a database from SQL Server 2005 to SQL Server 2000 (even if it was in compatability mode 80). The disk structures are...

That's why I keep pushing for multiple offsite file servers. All I want is 4 distributed around the district (we are a K12 public school district) where I can...

Here's an answer you might hear where I work:

:hehe::cool:

Giving a user/role access to a stored procedure is a means to allow users/applications to access database tables without giving them direct access to the tables. If you don't...

Take a look at the following code. Hopefully it will help you determine what you need to do accomplish.

/*

Create temporary tables for testing

*/

create table #MyImportTable...

What is the result of running the following from an earlier post?

RESTORE HEADERONLY FROM backupDevice -- replace backupDevice with the filename of the backup diskfile.

Helps, but I have one more question. What is the DDL for the final destination table?

😎

First piece of advice, don't shrink the database. If you do it before the index rebuild/defrag, you'll most likely fragment the physical data file as it will grow as...

Two things. One, have you looked up master database in BOL? It talks about restoring the master database. Two, when you started SQL Server to restore the...

Thanks, but that doesn't answer my question. Is there anything in the data files that will uniquely identify each row in the import file?

😎

You want to use a Flat File destination in the data Flow to create a csv file.

😎

"Only Capitalists can kill Capitalism; by exploiting it's core principals at the expense of and to the detrement of the general public instead of working with the principals of the...

Does the data have any data elements that uniquely identifies each row?

Andrew Gothard (10/15/2008)

It does say that, doesn't it. Wonder if :I've never tripped over that one before over the past almost 2 decades or what.

Not very intuitive though -...

Actually, since you posted this in a SQL Server 2005 forum, this looks like a good place to use Service Broker. Creating the csv file directly in a trigger...