Unfortunately I don't have the table def with me at home, but the idea is to simply update field1 to be a new rownumber based on the count of rows.

If...

LutzM (5/4/2011)

---

raistlinx (5/4/2011)

---

...

Yes that is what I understood the problem to be from the analyst who gave it to me. I knew it had to be a common problem. Is...

ChrisM@home (5/4/2011)

---

Did your select look like this:

SELECT field1 = (RIGHT(('00000000' + convert(nvarchar(8), ((SELECT count(*) + 1 FROM table1 o WHERE t.field2 > o. field2 and t.field3 = 'xxx')))),8))

FROM table1 t

WHERE...

WayneS (11/3/2010)

---

Hey guys - the reason I asked is two-fold:

1. If the service account running sql server has the "Perform volume maintenance tasks" right, creating even a 1TB db will...

Craig Farrell (11/3/2010) Sorry, reading back that was a bit rougher sounding than the joke I meant it to be. Thank you for taking that in good humor anyway....

Jeff Moden (11/3/2010)

---

Nope. Go back and look. The OP asked how to drop all the...

For writing? Slower than a single drive.

Leo.Miller (11/3/2010)

---

I'd be interested in seeing real times around this. I recently did an upgrade of 7 SQL 2000 databases to SQL 2005, including doing collation changes on all databases....

Leo.Miller (11/3/2010)

---

raistlinx (11/3/2010)

Because of the time it takes to create a new clean DB. Often times in developement you may want to clean out the tables quickly to have a...

WayneS (11/3/2010)

---

My question is: Why would you want to do...

SELECT 'DROP TABLE ' + name FROM sys.tables and run the result

I wrote this for a recent project, does this help?

SELECT 'IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = '+ name + ') ' + char(13)

+ 'CREATE...

You could have a look here: http://msdn.microsoft.com/en-us/library/ms176029.aspx

Also, if 'remote admin connections' is not set you cannot connect remotely and must do it at the server physically.

Have you ran DBCC UPDATEUSAGE lately?