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)
Francis
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
Francis
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...
Francis
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.
Francis
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...
Francis
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?
Francis
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...
Francis
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...
Francis
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.
Francis
April 1, 2005 at 7:58 am
Now that's a nice enhancement. Thanks for the update Scott.
Francis
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
...
Francis
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...
Francis
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.
Francis
March 14, 2005 at 2:18 pm
Viewing 15 posts - 271 through 285 (of 597 total)