If you are using the temp table in another DTS object you will need to make it global ie ##fileexists

In the UK most jobs dba jobs are advertised between £25000 and £60000, with some jobs in the banking sector (London) paying more (or towards the top end).

Saw one on...

Does SQL shutdown or is it not responding to that netlibrary?

I had a problem on a server a year or so ago where once in a blue moon all 'named...

There is an option NOT FOR REPLICATION which you can use when you create the trigger.

Never used it myself, hence best to read BOL

see the t-sql reference for 'CREATE TRIGGER'

Regards

Steven

...

You can, but it required modifying the database using the 'alter database' command which you don't just give to anyone (espically on a production server!).

Also remember after setting the recovery...

If you are running sql 2000 enterprise manager, you can find out who is in an nt group via EM

go to add a new login.

click on the ... next to...

I agree, but they didn't change the sql server exe in that release. The way to tell is to check the version on the netlibrary dll

It would need to be designed into the frontend.

It may be easier (and quicker) for the dba to change all the passwords. The usernames could easily be extracted from the...

sqldiag writes its output into a file (the default it the sql logs directory)

Take a read of the sqldiag Utility in books online.

sp_password will allow people to change their password, but they need a way of running it eg isqlw, osql or an application.

I think it is because the changes are so minor

ie 1 install problem

1 MDAC memory leak

1 new feature on the Network Library (ie disable...

Have you tried running sqldiag.exe when the problem occurs to capture what is happening inside sql?

If you get enough content in an area, you could specialise some of the newletters eg DBA, T-SQL, Security. Along the same sort of lines as the forums.

Format looks good.

For the 'submit' to work on the question, would you need to be logged into the site,

or does it work by posting the email address?

Great Test, a little short maybe.

Both the C2 audit questions I had got me, since I have never used it. (Learn something every day)

Cheers