I don't see the -ReplicationType flag in your command. Perhaps it is optional in SQL 2000 but required in 2005. I'm guessing on this one. Try adding the flag to...

There is an issue with using sp_rename. It does not trigger a DDL event. So if you have Database or Server Triggers that are watching for DDL events, then you...

Adding to what Mark posted above, this would show you the rows that were identical in both:

select * from Sep2006

INTERSECT

select * from Sep2005

To be able to "Read" the mirror requires creating a database snapshot of the mirror database which requires the Enterprise Edition. Not worth the cost in my mind if the...

The issue with aliases in SQL 2000 was if you had an alias that was the same as a column name, it would use the column in Order By clauses...

The OS and/or other applications on the server are using too much memory. SQL Server can not get enough memory to run CLR.

Firt of all, you need more memory. I...

I'm on the other side of the fence. It is in the standards i have written for developers to use. I require the use of nolock except in cases where...

My boss asked me yesterday to tell him the size of our largest database and our average database size, so I wrote the following script yesterday that uses sys.database_files to...

Why can't you just do this:

Declare

@strSQL nvarchar(max)

SELECT

@strSQL = '...

Since you're using SQL 2005, if you really want to have separate date and time columns, I would use a datetime column to store the datatime and then add 2...

Just do check, do you have the .Net framword 2.0 installed on that server? Did you install Service Pack 1 for SQL Server Express?

SQL Agent must not be needed for this then.

To be honest, i've never used SQL Server Express. I would assume that it has it, but I can't be sure.

Where are you seeing this? In the Management Studio? The little server in the registered servers with the green circle and a while triangle means that it is running. If...

No, the MS tech was correct. SQL Server express can be the witness. I'm not using it as a witness in my environment, but many people are. What I am...