Much like Andy, they have sadmin rights on development and I use SQL Compare to make find out what they have been upto. One rule we have in place...

Steve,

That was my initial thought. However, these jobs now run perfectly and nothing has been changed...ie..we did not add BI\Administrators back into the SysAdmin server role!

Mdamera,

We have WinNT Authentication...

Interesting topic!

The worst I have had and i own up to some of it being my doing was that fact that we had 12 logins set as SA. All...

The only product that we have purchased is the RedGate bundle. It works well for us.

I am currently looking at NetIQ's Management suite, but I don't think management will...

Hey,

If deadlocks increase, you can run a trace and specifically look for deadlocks. You can then identify the spid that was rolledback and also the spid that completed it's...

Are these two seperate tables?

If so, I presume in the Colours table you have a foreign key that you could join into the primary table?

Maybe posting (brief) designs of your...

Yep, Sourcesafe is good and also, Steve Jones published a very good series on change control using sql server and sourcesafe a while back...Well worth reading.

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp

Andy,

Great article. I think this topic is fantastic. Probably one of the best area's on this site, even tho there are only three entries. It's a good...

Steve,

Excellent idea! Certainly save me time by printing out articles etc and storing them myself. Quite often I don't have time to sit at work and read through...

Nice article.

Like a number of people who have replied, I do use Hungarian Notation, but only in for variable declarations in VB/SQL/ASP or whatever I am using.

To be honest, before...

Great article Andy.

I fully agree. With more and more archive tables, the resources on the Server do increase and who knows, if you have a fair number, it could...

Great Article Steve and quite probably happens more than we realise...!

Aside from SQLServerCentral.com a good source of security information is http://http://www.sqlsecurity.com.

Clive Strong

clivestrong@btinternet.com

137 and counting....

I'll catch you up yet, Antares!

Clive Strong

clivestrong@btinternet.com

Or failing to back it up, you can re-create the Northwind DB for future use.

From the command line go into the mssql\install directory and run the following...

osql/Usa /Psapassword /Sservername /iinstnwnd.sql...

Correct.

Both Pubs and Northwind are test db's. You can do with them as you wish.

Clive Strong

clivestrong@btinternet.com