Viewing 15 posts - 36,976 through 36,990 (of 39,717 total)
If you use the SQL XML integration to retreive data from a URL, then IIS is the server which receives this request and sends it to SQL.
Steve Jones
October 8, 2002 at 9:55 am
The reason often is that functionality in replication may break if you start with the subscriber.
Steve Jones
October 7, 2002 at 2:41 pm
only if clients need it. It tends to ferret out those using it so you can switch them TCP/IP.
Prior to 7, possibly with 7.0, it cannot be removed. I do...
October 7, 2002 at 2:39 pm
ODBC, AFAIK, is no longer being worked on at MS, so the OLEDB drivers are getting the latest enhancements. For basic selects, might not matter. For more complicated things, like...
October 7, 2002 at 2:38 pm
The easiest way to do this, IMHO is to use a temp or perm table and populate it with a loop to run through the main data set and get...
October 7, 2002 at 9:45 am
Not sure about using a SAN. I believe it will work, but we are using a SAN at my company for other servers and there are issues. Enough issues that...
October 7, 2002 at 9:18 am
I think Backup and restore will work for the dbs. I'd do that. If you need logins, use DTS.
Steve Jones
October 4, 2002 at 4:11 pm
I avoid it. Easy to forget when you rebuild a server or install a new one. Try to set things up in a DBA database that I attach to all...
October 4, 2002 at 3:20 pm
Dislike the agent backups. Prefer to keep the KISS principle in place. Plus in an emergency (and I've had a few), I'd rather go to disk if I can before...
October 4, 2002 at 3:17 pm
Interesting. I get the same thing.
I'll try to dig into this.
Steve Jones
October 4, 2002 at 3:16 pm
use combination of charindex, and subtring and replace
Get the substring of hte numbers and do the replace on these. Then contactenate that with the substring of the rest of the...
October 4, 2002 at 10:10 am
You may never know the "why". If someone did this, you would have to ask them.
To get them back, I think you could drop this as "sa". Maybe need to...
October 4, 2002 at 10:01 am
Not sure either. I know when you install SQL 2000, it wipes out the registrations. There is a Q article that says this is by design and you need to...
October 4, 2002 at 9:58 am
Do you get this in QA or in an app? In QA, there is a 255 limit, which might be reduced to 128 for N' strings.
Steve Jones
October 4, 2002 at 9:45 am
Viewing 15 posts - 36,976 through 36,990 (of 39,717 total)