If you're using SQL Server 2000, then DBCC DBREINDEX will lock the table it's indexing. That means you're likely to encounter timeouts and so on in your application as...

Simon

I think this is what I'd do:

(1) Back up all your databases

(2) Test that you can restore your backups to a completely separate server from your cluster

(3) Uninstall SQL Server...

What have you tried so far? I would advise you to read about the RANK function and see if that helps you. If you're still having trouble, please...

You seem to have run out of steam a bit there, Aaron! When you get round to posting the rest of your select statement, please will you also provide...

Still need more information. The tables that you want to copy - are they cleared down and repopulated every day? Or do they have new rows added every...

Replication? DTS? There's a couple of options for you, but we'll need a bit more information before being able to provide any solid advice.

John

Are you asking how to pass a parameter to a batch file, or how to connect to SQL Server from a command prompt? If it's the latter, look up...

There are lots of options in that dialog box, one of which is to script out the primary key constraint. Have a play with those options, and see if...

I'm not clear about whether your table already exists in the second database and you just want to copy the data. If so, just use DTS or INSERT INTO...

There must be different degrees of "exactly the same" otherwise you wouldn't need to do this...

Seriously, though, just script out the table and then run the script against the second...

Frances

If you take the second "as [Name]" out of your second query, it should work.

John

If you declare a variable, it is only visible in the context of your connection. If you then use EXEC @select_var to run some code that contains the name...

Sandy

It's doing what you ask it to. SELECT * means "select all columns". SELECT 'x' means "select the value 'x'" (regardless of what data is actually in each...

Yes, just create a temporary table with an identity column and insert from table A into that. Then find the max ID value from table B and insert into...

Kiruba

Because you've converted your dates to varchar, it's comparing string values and not date values. In those circumstances, '03/10/07' will always be greater than '01/01/08'.

John