Hi,

In our shop I've installed a CTP of 2008 on a VM for test, in production we have only 2000 and 2005, almost finished migrating the majority of systems to...

Hi,

Agree with the last poster, with the size of removeable storage devices these days a stolen backup is very easy to get out of a server.

Yes we do encrypt databases...

Hi,

As stated by others media errors are of cause a concern, but other things are even more relevant in my view.

Restore procedures, just restoring the DB in many cases does...

Hi All

OK to see that VM performance is up, but in my view a worthless test, deployment in a VM environment is done to consolidate servers, so in practice the...

Hi,

I also disagree like others here, this is what I found on the net:

There are two password options for SQL Server logins: CHECK_EXPIRATION and CHECK_POLICY. CHECK_EXPIRATION encompasses minimum and maximum...

Hi Jeff

We have the same functionality in our SAN, but this would of cause overwrite any code changes currently deployed. So a too invasive approach in my view.

//SUN

Hi,

No SP2 does not show up in add/remove programs, and according to several articles i googled, the only way to get SP2 off a sql s005 install is to remove...

Hi David

That can be used as well, I wanted to use @@version, since it worked on earlier versions as well, I still have a few 7.0 installs running. But then...

Hi Steve

I changed the table and package to contain and use connections strings, since all my servers are in different domains, so integrated security is not use full for all....

Hi All

Thanks for all the input, even though some was in the funny league. But I managed to convince both developer and his project manager that the code needed changing....

Hi,

Playing a bit with the posibility for having a table with diffrent queries i ran into the problem that the table transformation also needs to be dynamic. Any ideas how...

Hi,

One thing that I was thinking to change as well, since I also need to scale it to around 40-50 servers all ranging from the odd 6.5 to s2k5.

The following...

Hi,

Had the same problem as everyone else here, but really powerfull and expandale solution. Thank for sharing !!

Reagrding security across several domain I think the best would be to use...

Hi,

My 5 cents worth.

Internet is a mirror of all sides of life. The change today is that anything can be found which before was more difficult to see or get...

Hi Nathan

Thanks for the link, I just wonder if no one really are using the protocol encryption and have some experiences to share?

//SUN