Viewing 15 posts - 3,331 through 3,345 (of 5,103 total)
Please,
And when you're done can you reply back?
Cheers!
July 6, 2005 at 3:25 pm
May I recommend NOT to use TRUNCATE_ONLY!!!! ![]()
you should be able to do it with a "normal" BACKUP LOG
from the turncate_only point forward your...
July 6, 2005 at 3:20 pm
Yeah! he even said that ![]()
![]()
![]()
![]()
And Remi does have a point it can be easily changed in:
http://www.sqlservercentral.com/forums/images/rankimages/1500.gif
July 6, 2005 at 3:12 pm
He was Probably trying to demonstrate how to convert month number to characters ![]()
July 6, 2005 at 2:50 pm
I guess you will have to post this one on the Suggestions Forum ![]()
July 6, 2005 at 2:47 pm
The rectagles are for MODERATORS ![]()
http://www.sqlservercentral.com/forums/images/rankimages/moderator.gif
do you want the rectangles or the AVATAR ? ![]()
July 6, 2005 at 2:41 pm
Well Lets step back from the begining:
You can use the ENABLE/ DISABLE for ALL constraints Except PRIMARY KEYS.
To prove my point this is the query you are after:
select TABLE_NAME
,CONSTRAINT_NAME
, OBJECTPROPERTY(OBJECT_ID(...
July 6, 2005 at 2:34 pm
Remi,
You can't check from TSQL the conectivity of a Linked Server because as Brian said above the batch will be suspended if an error occurs. The solution is DMO, ACTIVEX or...
July 6, 2005 at 2:10 pm
That is true is just me being lazy not to type a case statement including the Right. The point is that because you are grouping by one column expression instead...
July 6, 2005 at 1:55 pm
Time for me to agree with ALL your points ![]()
July 6, 2005 at 1:41 pm
Viewing 15 posts - 3,331 through 3,345 (of 5,103 total)