Viewing 15 posts - 271 through 285 (of 597 total)
You may also want to try something like :
http://www.sqlservercentral.com/scripts/contributions/1005.asp
or look into a product like Apex SQL Doc. (http://www.apexsql.com)
April 27, 2005 at 8:12 am
I use to like xp_smtp_sendmail until I wanted to send the results of a query and could not. Now I use my own stored proc. For samples see:
http://www.sqlservercentral.com/scripts/contributions/287.asp
http://www.sqlservercentral.com/scripts/contributions/355.asp
April 27, 2005 at 7:55 am
If you have 20 CALS purchased and 50 workstations log in, SQL Server will accept all 50. Keep in mind the CALS are really for the workstation so if I...
April 15, 2005 at 8:58 am
see http://www.sqlservercentral.com/columnists/wbrown/fourofakindbackupsoftwareshootout.asp for a great comparison. I am using Red-Gate's SQL Backup product which works well and was inexpensive.
April 15, 2005 at 8:10 am
Keep in mind that this is manually maintained. If you purchase CALS there is no requirement to update this field. If you don't update it there is no impact except...
April 15, 2005 at 8:06 am
Shas3 are you saying you are having this issue? Did you apply some hotfix and you now have some problem? Which hotfix did you apply?
April 8, 2005 at 9:07 am
Brian I had to read your explanation a couple of times to understand. Not because you weren't clear, but it is complex. If prompted to overwrite some library it's important...
April 8, 2005 at 9:03 am
I've never heard of this happening. How would some dll or other component get unregistered with SQL complaining or outright failing? You can't even revert back using...
April 8, 2005 at 8:39 am
I can't believe I fell for it. Now I just wish it were true. I'm glad I read to the bottom before forwarding it on.
April 1, 2005 at 7:58 am
Now that's a nice enhancement. Thanks for the update Scott.
March 29, 2005 at 7:46 am
More info I think the erro has to do with dynamic SQL. I want to be able to return only x rows so I have coded:
IF EXISTS (SELECT name
...
March 24, 2005 at 1:13 pm
? Please explain what you are doing. Are you executing some select statement from QA that is installed on an XP workstation? Is the SQL Server instance installed on a...
March 24, 2005 at 8:24 am
Look at dbcc shrinkfile in BOL. If you do a search on transaction log shrink on this site a number of helpfull discussion threads appear.
March 14, 2005 at 2:18 pm
Viewing 15 posts - 271 through 285 (of 597 total)