As far as I know Lynn's solution is the only one. You can create a table that has the same column types as the exec result, and then insert into...

It depends. Among others, it depends on your location (country, city). Have you had a look at job advertisements in your chosen area?

Andras

First run

RESTORE HEADERONLY FROM DISK = N'c:\myBackup.bak'

just fill in the backup path.

This will give you information about what backup sets there are in this backup file, whether they are...

Assuning that you are using SQL Server 2000 (since these are the 7 and 2000 forums, and I hope you are not stuck with 7

Karthik,

also, instead of using cursors to iterate through the tables you may want to consider sp_msforeachtable . (this is not in books online, but searching these forums or google helps...

Karthik,

It depends on how log it takes to execute the above query. If it takes more than a few seconds, then the answer is likely that it does not matter...

You can read more about local and global temporary tables on http://msdn2.microsoft.com/en-us/library/ms174979.aspx

towards the middle of the page.

Andras

If you want to share a temporary table you could use global temporary tables. These have two # in their names, like ##foo.

These tables are created in the temp db....

Hi Karthik,

it very much depends on your requirements. E.g. whether you can recover from an error, or you need to abort the transaction immediately. I would recommend you to read...

Hi Karthik,

By row-by-row I assume you mean some kind of predefined ordering, like what sequential files have. But many times data does not require such an ordering at all. Do...

Have a look at @@error

http://technet.microsoft.com/en-us/library/ms188790.aspx

Regards,

Andras

Something is connecting to the server before you do. Does this machine have a console? If so, could you disable the network and and restart SQL server from the command...

If you want to know when the table's schema has been altered, you can look at the modify_date column of sys.objects.

This works retrospectively.

If you only query the data in a...

Could you also try to start your server from the command prompt and then connect via osql?

Andras

Sorry, before your comment I have updated my post to refer to 2000. The Management Studio stuff is not relevant.

can you connect using osql?

Andras