What SQL Server version/pack needs to be installed to use srvinfo, or could you point me to some documentation on it. I checked BOL and didn't find anything. The reason why I ask is that I have some servers that xp_cmdshell 'srvinfo -ns' works for while others don't and SQL Server Version as well as […]
2003-06-16
2 reads
That's the one. We'll be contacting MS this afternoon. Thanks for your help.
2003-06-16
1 reads
Just thought I'd throw my hat in the ring... Looks like there are multiple correct answers. #1 is certainly correct and is the easiest to perform. Kalen Delaney's "Inside Microsoft SQL Server 2000" (p 164) details #4 as the longhand procedure for extending the number of error logs that are retained for a default SQL […]
2003-06-13
1 reads
Yuo could think outside the box... create a temp table with the values for your IN clause, and then do a join. For example, if you want: where col1 IN (2,5,7) create a one column table that contains three records with these values, and then say: where col1 = #tmp.Col Depending on your particular case, […]
2003-06-13
1 reads
2003-06-13
1 reads
'SA' is mapped to 'DBO' ( as I can see in the user list ). But when I right click on that database -> properties -> it shows the database owner as some other ID. I dont know what is going wrong. Thanks.
2003-06-13
I agree with point 6. Event if you seem like an asshole, you have to come to a point where you say no. Scope creep sets in and you look like the idiot at the end of the day. Your example of messages not to put in has got many people in trouble. Myself included. […]
2003-06-13
2 reads
If you mark a table as pinned then it has little or no affect the first time you carry out an operation after it was pinned. It is the 2nd and subsequent time that it works. Pin your table, do a SELECT * FROM your table then do your test. The downside to pinning a […]
2003-06-13
1 reads
Frank, is it not to early in the morning for more techie humour? Not enough coffee in system yet! Cheers, Crispin
2003-06-13
Hi Andy, I sometimes think I surrender my privacy when I enter office building. I certainly don't want to discuss this with the users! But in a way even this is the problem. Do you intentionally keep the users 'stupid' (not always a bad idea ). Or do you tell them, what you are able […]
2003-06-13
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers