Insert into Table1 (col1, col2, col3, col4)

select ColB, 45, ColA, getdate() FROM Table2

If you want the default value as specified in the table to go into the column, don't...

DBCC IND is an undocumented command that shows internal details of the index. It's not really useful to someone getting started.

I would suggest you read the sections in books Online...

Let me guess. Full recovery mode, no log backups.

Not enough info right now to give useful advice. You can read the following for background info.

http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic554115-149-1.aspx

What are you looking for? There was a good explanation in the newsletter for 14th Aug and there's a discussion in...

Or

select * from #Like_Test

where Col1 Like '%Cu/_%' ESCAPE '/'

Odd.

The only thing I can think of is perhaps the CD is slightly damaged and the one drive is just better at reading through the damage than the other.

Try copying...

Same OS? Is one perhaps a 32 bit OS and the other a 64?

Where did you get the installation files from? It may be worth trying to get another copy and install from that. Sounds like one of the files is corrupt.

If I understand you correctly, you're looking for some way to prevent anyone from reading your database from a tool like management studio?

If so, it can't be done. If a...

Odd. I suspected it was a problem with the file's max_size setting, but apparently not.

Grasping at straws here... what's the command that you're using to shrink the file?

SQL 2000-related questions should rather be posted in the SQL 2000 forums in future please.

FirstTable has 1 lakh record , Second table has 2 Lakh record and Third and...

The two instances should be listed separately under the Process object. Identifying which is which is a little more tricky

As well as the memory counters, add the counter "ID Process"...

Joe Torre (8/16/2008)

---

If more than one user at a time is querying these tables SQL Server will put locks on the tables while it internally creates temp tables to speed...

You can.

What would probably be best is to make the entire thing handle an number of rows (set-based processing instead of row by row) and then use a cursor...