Viewing 15 posts - 38,851 through 38,865 (of 39,466 total)
You are welcome. Glad we could help (if we did). You might try Inside SQL Server or Advanced T-SQL Programming or the Guru's Guide to T-SQL. All are listed in...
November 26, 2001 at 8:09 pm
The Internet Connector was renamed for 2000 to be consistent with IIS, SMS, etc.
Steve Jones
November 26, 2001 at 2:41 pm
Be sure to check security. The account under which SQL Server runs needs to have rights to delete these files from the OS.
Steve Jones
November 26, 2001 at 2:40 pm
Do you need to script this? Sorry, don't have BOL handy now, but search for "database status". You can right click in EM and select properties, then choose your action.
Steve...
November 26, 2001 at 1:04 pm
If you have users that are not authenticated, ie, accessing through a web server, you have to use Per Processer licensing. If your users are employees and authenticated, then you...
November 26, 2001 at 10:36 am
I have an article discussing why this is a bad idea coming next month. Bascially, there are tons of ways you can encrypt data, pick up Bruce Schneier's book "Applied...
November 26, 2001 at 8:48 am
Yes I do it manually. Updating lots of objects is tedious, but there are a few tricks.
1. Naming conventions. Keeping all objects named according to some rule makes things...
November 26, 2001 at 8:45 am
That makes sense. I usually pipe to a file and then grep or findstr for any errors.
Steve Jones
November 26, 2001 at 8:41 am
SQL Server doesn't audit indexes, so you can only check which indexes there are now. If you post the section of the stored procedure that is slow, we can try...
November 26, 2001 at 8:39 am
November 24, 2001 at 8:16 pm
I don't have this folder in my servers. If I check for this value in my SP1 file, I don't see anything. Perhaps the SP is corrupt? Are you applying...
November 21, 2001 at 4:18 pm
Are you saying that the speed of the web server is dependent on EM being open? Are you executing the same query in the web page and in Query Analyzer?
Steve...
November 21, 2001 at 4:11 pm
November 21, 2001 at 4:09 pm
November 21, 2001 at 11:55 am
Do the VB programs mark the times? If not, I do not know how you will get this. There are some process utilites at http://www.sysinternals.com that can help you find...
November 21, 2001 at 11:55 am
Viewing 15 posts - 38,851 through 38,865 (of 39,466 total)