If all your tables have a clustered index then

SELECT object_name(id),SUM(rows)

FROM sysindexes

WHERE indid=1

GROUP BY object_name(id)

WITH ROLLUP

indid=1 is the clustered index

I don't have BOL to hand but I seem to remember that you can do something like SELECT @@SERVERNAME

Developer edition is supposed to be limited to 5 connections but apart from that they should be identical.

There is an explicit role called db_accessadmin that allows existing logins to be added as users in a database.

Where possible my approach would be to have Windows authentication and granting...

It sounds like someone set the initial size of TEMPDB to 15GB so if you reboot it will get built at that level.

You can check this by running the following...

If you CREATE TABLE #TableName it should be for the current connection only.

If you CREATE TABLE ##TableName then it will persists until the creating connection disconnects.

Thanks, Old SQL 6.5 habits die hard. Although I know it exists I rarely use the object_name function.

Does anyone know the correct syntax for getting decimal places to appear...

There are two solutions and they require db_owner or db_DDLAdmin privileges.

If you want to DELETE FROM Table1 then use TRUNCATE TABLE Table1. Not only will this reset the Identity...

The problem is not my creating objects out of sync the problem is that I have inherrited a plethora of ancient databases with convoluted dependencies and need to be able...

Is the nature of the single stored procedure such that it cannot be broken out into much simpler non-dynamic SQL?

Let us assume that the proc cannot be broken out.

Even if...

Sir Bob Geldoff says his productivity is directly proportional to the number of emails he ignores!

He also says that e-mail can be counter productive because the rapid fire responses it...

I would use the ADO Command object to call your stored procedure.

I don't have my ADO books to hand but it is a case of setting

Command.CommandText to the name of...

It probably doesn't apply in your case but if a clustered index is placed on the field that has the LIKE condition it works quite well because clustered indexes are...

Apparently it is possible to run a standard diesel engine on recycled vegetable oil.

There is a bloke around here that gets his supply of vegetable oil from fish and chip...

The methods discussed in the following article can be used

http://www.sqlservercentral.com/columnists/rmarda/letsblockthedba.asp

Of course the instant you use them you will probably breach your support agreement.

Does your 3rd party app need the rights...