Rajesh kasturi (4/24/2009)

---

Hey

This is the script for you.

OSQL -E -S [SQL Instance Name] -n -i [path ..c:\] >> c:\resutls.txt

The above script use Windows authentation and connectes to the...

to run the scripts from the command line you can use SQLCMD.

http://msdn.microsoft.com/en-us/library/ms170207.aspx

or else you can open the scripts in SSMS using File -->Open File

What criteria defines a bad record?

Are you sure you are running the select against...

glad it worked.

check in SSMS that it has created the table in the correct database, if you see this new table in the explorer then you will be able...

You should probably rename the table to something a bit more useful in the import process.

But too select from your current table enclose the table name in []

select * from...

Easiest way is to use the Import / Export wizard in SSMS

yes just use a database connection as the datasource

Yes it is possible, use the Excell data source, perform any transformations that are needed, and send the data to a flat file destination.

for this i would use some staging tables in SQL server, use SSIS to create the tables, load your two sheets into the staging tables, then join using...

You can not directly backup from SQL server to Access.

To do this, you will need to export all your DB objects from SQL server to Access, The tables can...

Are they both running on the Physical Server, or on a Virtual Server?

stineo (4/17/2009)

---

I have have restored the same database backup on both instances so both databases have same indexes, same statistics, same amount of data and same number of users (Actually...

This is because the...

I use redgate sql compare for this and it works really well..