It makes sense to keep running the backups locally to each server. Not only is it reliable but that way you have a weeks worth (or whatever retention period you...

Hi there.

We've been having the same problem and it's taken ages to find the solution. It would seem that when you start an SSIS package from a scheduled job the...

SQL 2000/2005 databases of different collations can sit side by side on the same server quite happily. Some of our servers have 3 or 4 different different collations across all...

What we do (and I got the ideas from posts on this site!) is to have dedicated "DBA" databases on each server that hold tables and stored procedures to capture...

I don't believe you need to install SP1 first. From the Microsoft website:

"Service Pack 2 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative,...

Hi there

When you open Management Studio it trys to connect to the internet to check certificates. If you have internet access disabled on your servers like we do then it'll take...

Hi Sam

We went through a similar process to update any jobs that had user AD accounts as job owners. We found that when we made the change via Enterprise Manager...

I really should read other posts before sticking my own up! Just read Log - Creation of objects......

The application speeds are fine ,faster than 2000 in most cases so the server isn't really the issue. It's my desktop and using SSMS for general admin across all servers. Don't...

I'm finding 2005 really really slow as well. And I'm not talking about running fancy queries or anything. I mean opening up management studio on the server - 20 or...

Hi Garrick

Not sure if this is what you need but the system stored procedure sp_helpsrvrolemember will tell you all the members of the sysadmin role. We have the results of...

That would be fine for the user databases but you seem to want to do that for your system databases as well i.e. master and msdb. I would say you...

Thanks for the info.

Actually everything's staying on the same server but sql was installed incorrectly and we've got collation issues across databases. I want to rebuild the master to...

Thanks to you both - the sp_MS_marksystemobject procedure fixed it.

We have a new security analyst in our company who's concerned about the lack of complexity on our SQL passwords. Although...

There's an undocumented utility called pwdcompare that lets you compare the value stored in the password column of the sysxlogins table against any string value. What you can do is...