Viewing 15 posts - 3,751 through 3,765 (of 5,103 total)
Did you read Remi's anwser? You can't use x = NULL
You should either account for those cases independently using IS NULL or the Change the ANSI_NULLS to ON (this...
May 4, 2005 at 8:23 am
As David Posted you are going to need the COLLATE statement
and you will have to use it either at the "join" , "where" or at both clauses depending on the...
May 4, 2005 at 7:55 am
You can run distrib.exe fom the command line!
Search BOL for "Replication Distribution Agent utility" for more info
hth
May 3, 2005 at 10:27 am
Yes, that will do what you need.
Becareful to really ensure that you don't need that initial check!
May 3, 2005 at 9:39 am
... and viceversa ![]()
May 3, 2005 at 9:32 am
Don't know much about clustering but I know you can't rename an instance
May 2, 2005 at 3:15 pm
Christopher,
When you use EXPLICIT Transaction commands you have to call COMMIT or ROLLBACK after you call BEGIN TRANSACTION.
Lets assume that in "your post" you get an error in the...
May 2, 2005 at 2:42 pm
Actually, I would like to suggest you use a stored procedure instead of a view if at all possible.
May 2, 2005 at 2:33 pm
Declare @list varchar(200)
set @list = '688,708,87,88'
Select * from Employees
where charindex(','+ cast(empID as varchar(10)) +',', ','+@List+',') > 0
May 2, 2005 at 12:40 pm
That Error handling should "In my opinion" be used only when you are trying to perform several DML as a single transactional action. You should not need that for a...
May 2, 2005 at 12:34 pm
No Problem, Feel free to post again if you find any more problems
May 2, 2005 at 11:43 am
When you run that script from a Job it is using SQL Server Agent service credentials. Services do not know anything about mapped drives because that information is kept in the...
May 2, 2005 at 11:37 am
In your case
-max server memory is not needed. (use dynamic)
-min server memory neither (use dynamic)
and because I am recomending dynamic allocation "working set size" does not need to change...
May 2, 2005 at 11:24 am
DBCC setinstance (objectname, countername, instancename, value)
hth
May 2, 2005 at 11:17 am
Viewing 15 posts - 3,751 through 3,765 (of 5,103 total)