-
Drop the empty schema first before you can remove its user
A few weeks ago, I ran into an issue with a SQL Server 2005 database restored from a Sql Server 2000 backup file. I want to share how I resolved this, hopefully it will be helpful to somebody. You can restore a Sql Server 2000 database backup to a SQL Server 2005 server. When pages […]
-
No edit in DOS on Windows 64-bit
I’ve been working with 64-bit SQL Server 2005 laterly. I just finished setting up a 2-node SQL Server 2005 cluster with SP1 on AMD 64-bit processors with Windows 2003 R2. 64-bit is really sweet. Anyway, I guess the venerable DOS editor named edit is not ported to 64-bit machines. I figured this out when testing […]
-
Fixing remote connection problem for Microsoft SQL Server 2005
Today I played with a server setup a few months ago but has since been neglected. It has Microsoft SQL Server 2005 Standard Edition on it. I got the following error when trying to connect to it using sqlcmd integrated authentication from my workstation: C:\>sqlcmd -S MyServer HResult 0x35, Level 16, State 1 Named Pipes […]
-
Setting sqlcmd environment variables
In this post, I talked about how you can set your default editor for sqlcmd. At the end of that post, I asked how to make that variable persist. To do that, you can create an environment variable. For example, you can create an environment variable called sqlcmdeditor, and give it the value of your […]
-
Don’t over do it, Sql Server; Watch out, Oracle
SQL Server 2005 was released in November, 2005. I actually played with it much earlier than that. Overall, I am pretty happy with it. I think it is a great product, and will give Oracle’s namesake RDBMS a run for its money. Previously, there were a lot of arguments against Sql Server for its perceived […]