Do a transaction log backup before shrinking the log.

look into SET QUOTED_IDENTIFIER OFF

Once you do that, you'll see the next error which is datetime/char conversions.

I know this thread is over a year old but I'll post in case someone else runs into this problem.

I've run into the need to know how to remove TDE....

that's fine

After spending the day trying to figure this out I finally was able to get my diagrams!

With databases created in SQL 2000 there is a dtproperties table created in the...

Are you able to post the query you're running?

You'd probably get more help if you supplied the query in question.

Very cool! Didn't know about WITH TIES.

Thanks Mr. Bucket

You can install multiple named instances on a single virtual server, yes. You can cluster virtual servers. Yes, you can install multiple failover cluster instances on virtual servers.

This happens because the login specified has a different sid on the primary and secondary servers. The logins are mapped to database users by sid. When you restore a log...

Mirroring is an option. But you need to decide what you are trying to protect against.

If you're worried about OS failure, either will work.

If you're concerned with disk failure,...

If you're using SQL Server 2008 or 2008R2, you can use FILESTREAM.

http://technet.microsoft.com/en-us/library/bb933993.aspx

previous versions of SQL Server do not support storing/managing documents right in the database itself.

I actually laughed a little when I saw the answers. I didn't know 'THE' was a valid t-sql command.

DROP THE TABLE <TableName>

CREATE THE TABLE <TableName>

DISABLE ALL TRIGGERS ON THE DATABASE

good...

Restart your computer.

Then find the person pullin' the prank on you and kick them in the shin.

http://msdn.microsoft.com/en-us/library/ms345416.aspx

This shows how to start SQL Server in single user mode through adding startup options in the service. This is done through the Configuration Manager tool.

Make sure you are logged...

Read the following article, it explains how/why.

http://msdn.microsoft.com/en-us/library/ms188236.aspx

Ensure your account is a local admin.

Start SQL Server in single user mode ( -m option in startup parameters)

Login and make changes. (switch...