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...

Assuming that you have various methods of maintaining your data and can't put the logic in stored procedures try the following

INSERT INTO dbo.HistoryTable (column1, column2......column99999,Action)

SELECT I.column1, I.column2, I.column3 ,....column99999 ,

CASE...

Let us suppose that project A had a task called documentations and project B had a task called documentation. In a projects and employees schema these would be non-atomic.

If you...

Well you cluster for resilience so why wold you want to cluster on the same box?

When you install on a cluster the Enterprise Edition knows that it IS a cluster...

I used to develop using IIS5 and ASP and found that getting Visual Interdev to debug properly was an impossibility. For that reason I always developed a middle tier...