Viewing 15 posts - 38,836 through 38,850 (of 39,456 total)
Be sure if you open our firewall, you only allow connections from the IIS server. Here we have 2 NICs in the IIS server, one to the Internet and one...
November 27, 2001 at 10:50 am
November 27, 2001 at 10:48 am
I do not think so, but I could be wrong. I haven't used the Data Driven Query very much, but I have seen than any transforms in DTS are slow....
November 27, 2001 at 10:45 am
I agree with Nigel, but your post is not really clear. What are these two tables? What is the related? How is an identiity related to the update?
Steve Jones
November 27, 2001 at 10:40 am
Can you post a sample data file (a couple lines) and I'll see what we can do.
Steve Jones
November 27, 2001 at 9:13 am
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
Viewing 15 posts - 38,836 through 38,850 (of 39,456 total)