Hi,

I suspect you cannot upgrade from a 32-bit SQL Server to a 64-bit SQL even if you are on a 64-bit O/S.

My problem was because the old version of SQL...

Robert, thanks for the reply, I resolved my issues. It took a bit of investigation and effort, but I resolved it.

I keep giving Microsoft too much credit, I figured...

Hi,

I needed to do the same thing quite a while back. We had servers running Windows 2000 and SQL 2000 and needed to update our service passwords on a...

For specifics on xp_cmdshell implications on SQL 2005 see the Books Online reference at:

http://msdn.microsoft.com/en-us/library/ms175046(SQL.90).aspx">

http://msdn.microsoft.com/en-us/library/ms175046(SQL.90).aspx

If your developers have sysadmin access, then they will be able to use xp_cmdshell...

Rick,

I was able to recover the master database in another way. No need to rebuild the master database. (I have not used that process since early SQL 6.5 and...

Gail,

When I attempted to connect this database with a different name, I got the I/O error message. I used my fresh install copy of master and restored over the...

It appears there is confusion rampant with this question.

It asks how large is the database. The question does *NOT* say anything about what are the total sizes of the...

My vote is for UTC with a caveat.

I supported an application that used UTC to store all date values and then had a ton of logic converting to and from...

I rebuilt our replication and got my answer.

Our source tables for these replications have compound keys using character data with only a few indexes. The underlying data is getting...

Roy,

Thanks for the tip (been using no-initialize for transactional replication for quite a while) I do not know if it is an option for merge replication.

I know in the GUI...

Andrew,

Thanks for the reply, but it is rather stark contrast to many articles I have seen discussing SQL Server 2000 and 32-bit services/applications.

I set the memory amount very high and...