Forum Replies Created
Viewing 15 posts - 2,236 through 2,250 (of 5,103 total)
-
RE: 2 server working as hot / standby
Yeah, yeah, yeah... all looks nice on presentations and usually the achievability of that is unrealistic. What would happen on the next 'upgrade', service pack, driver update, hardware refresh, backup...
-
RE: making a query into a view or sp
Correct. Make sure it does what you need
-
RE: SQL 2000 Error: 1203, Severity: 20, State: 1 Error
Microsoft Product Support Services
-
RE: making a query into a view or sp
Give this is a go, there are expressions in your code that are not complete like IIF with only one argument.
I tried to guess what you wanted...
-
RE: selecting by week?
One of your fileds is not a datetime!
Make sure they both are :
select * from xxx
-
RE: SQL 2000 Error: 1203, Severity: 20, State: 1 Error
In that case, the best bet is to call PSS.
-
RE: making a query into a view or sp
Is that working at all? I don't see where [Distinct Subform 1 query 1].ItemGroup is coming from
-
RE: Cluster IP Address Change
100% with Colin here. If you can afford to build a "new" cluster and perform a DB migration it will be A LOT safer!!!
Cheers,
-
RE: SQL 2000 Error: 1203, Severity: 20, State: 1 Error
Can you tell what is your service pack level ?
There has been issues like this reported on hot fixes: http://support.microsoft.com/?kbid=814654
-
RE: Listing tables referenced by a stored procedure
If you are looking for a 'reliable' way to do it
use information_schema.routines and check the routine_definiton column.
NOTE: this works only for SP and Functions
-
RE: 2 server working as hot / standby
By the way there is not such thing as 100% availability
-
RE: Conditionally Incrementing a Counter in a While Loop
@RandomUID Table is empty therefore @@rowcount will be 0 always
-
RE: Cursor repeats row
If the purpose is to send emails and you are planing to use xp_sendmail for that you will need the cursor!
Like David said change the position of your print statement...
-
RE: Error 208: Invalid object name ''''msdb.dbo.MSdistpublishers''''
Also, if your server got renamed you are in for that same problem!!!
Cheers,
-
RE: Cursor repeats row
What are you planning to do with the cursor? the above can be substituted for nothing at all.
Viewing 15 posts - 2,236 through 2,250 (of 5,103 total)