Viewing 15 posts - 15,826 through 15,840 (of 39,970 total)
David.Poole (6/23/2011)
June 23, 2011 at 1:31 pm
You backup the tail of the log if you are having issues with your database and are about to restore. It's a normal log backup.
This should help: http://msdn.microsoft.com/en-us/library/ms179314.aspx
June 23, 2011 at 1:21 pm
Monitoring solely off an iPad, Xoom, etc isn't the use case. It's an additional way to monitor, which can be handy if you aren't near a desktop/laptop.
June 23, 2011 at 1:16 pm
Hoping Comicon comes to Denver sometime.
June 23, 2011 at 1:11 pm
Probably. I'm not sure it hurts to be there, but I can understand it being annoying.
If you open a case, would like to know how you remove it.
June 23, 2011 at 9:54 am
So can you post all the code? REPLACE by itself doesn't change things. You would have to do this:
update mytable
set col011 = replace( col011, CHAR(10), '')
June 23, 2011 at 9:41 am
are there quotes in the name of the server?
Maybe this?
sp_dropserver '''ServerA; UID=DEVAccount;PWD=DEVPwd'''
June 23, 2011 at 9:40 am
Are you saying this doesn't work?
replace( col011, CHAR(10), '')
June 23, 2011 at 9:31 am
SQLRNNR (6/23/2011)
They are?
Truncate = D R O P T A B L E
Delete = D R O P T A B L E
I don't...
June 23, 2011 at 9:18 am
Just so we're clear, we're not talking about any user. XP will work fine for client applications. It won't run the SQL Server tools or dev edition.
June 23, 2011 at 9:16 am
Try this:
sp_dropserver '[ServerA; UID=DEVAccount;PWD=DEVPwd]'
June 23, 2011 at 9:14 am
AFAIK, the code is
sp_dropserver 'Servera'
No need for the name and pwd. You just include the server name as a drop or an add.
June 23, 2011 at 8:56 am
You wouldn't use Red Gate's SQL Source Control instead of TFS, it's a "with TFS". The RG product integrates almost any VCS with SSMS so you can check in/check out...
June 23, 2011 at 8:40 am
Eric M Russell (6/23/2011)
June 23, 2011 at 8:37 am
Viewing 15 posts - 15,826 through 15,840 (of 39,970 total)