Viewing 15 posts - 646 through 660 (of 687 total)
Do a transaction log backup before shrinking the log.
January 4, 2011 at 10:11 am
look into SET QUOTED_IDENTIFIER OFF
Once you do that, you'll see the next error which is datetime/char conversions.
December 16, 2010 at 1:12 pm
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....
December 7, 2010 at 12:20 pm
that's fine
December 7, 2010 at 7:59 am
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...
November 12, 2010 at 11:32 am
Are you able to post the query you're running?
You'd probably get more help if you supplied the query in question.
August 4, 2010 at 9:15 am
bitbucket-25253 (7/20/2010)
This should do it
SELECT TOP (5) WITH TIES Item, val FROM @TEST ORDER BY VAL DESC
Very cool! Didn't know about WITH TIES.
Thanks Mr. Bucket
July 21, 2010 at 12:43 pm
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.
July 12, 2010 at 6:18 am
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...
July 2, 2010 at 12:01 pm
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,...
July 2, 2010 at 9:52 am
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.
July 1, 2010 at 9:10 am
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...
July 1, 2010 at 5:14 am
Restart your computer.
Then find the person pullin' the prank on you and kick them in the shin.
June 30, 2010 at 8:48 am
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...
June 30, 2010 at 8:12 am
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...
June 30, 2010 at 5:56 am
Viewing 15 posts - 646 through 660 (of 687 total)