Viewing 15 posts - 38,206 through 38,220 (of 39,456 total)
Don't have time to check, but can runas take an input file like ftp? Like I did in the Pushftp article?
Steve Jones
January 25, 2002 at 2:45 pm
Can't you run a process using runas instead? This would alleviate the need to run as a domain admin (though you;d need an accoutn and pwd in SQL to run...
January 25, 2002 at 2:08 pm
I agree with Andy, but what you are asking is a little unclear. If you are expecting a SQL message to be sent when data changes, this is really a...
January 25, 2002 at 1:24 pm
lol, I wrote the Sybex SQL 2000 Design Study Guide:http://www.amazon.com/exec/obidos/ASIN/0782129420/qid%3D991345443/sr%3D1-8/ref%3Dsc%5Fb%5F8/102-5028696-8717706, Actually I wrote half of it. (second half)
Of course, if you read some of the user reviews of the Advanced...
January 25, 2002 at 1:20 pm
As a rule, I always use a domain user account, NEVER a domain admin account. You can substantially restrict the rights of the domain account, but in almost every case,...
January 25, 2002 at 1:15 pm
Haven't seen anything on these. They must have overhead to process and send the data, but no idea how much.
Steve Jones
January 25, 2002 at 1:11 pm
Haven't run into it, but no one is around when I run DBCCs. Haven't run dbcc dbrepair in a long time. I spoke with the developer from MS for DBCC...
January 25, 2002 at 1:09 pm
BTW, I don't really use App roles. Do you have a good reason for not just creating a role and assigning users to it?
Steve Jones
January 25, 2002 at 11:13 am
I think your app roles will need to cross databases and be setup for each databare. Not sure if you can have one app role that maps to others in...
January 25, 2002 at 11:10 am
The clusteered index is the key. Now in SQL 2000, the storage changed slightly for performance, but whether you search the clustered key (essentially data) or search the data, there...
January 25, 2002 at 10:11 am
Most people I know think my job is boring. Maybe bacause I am cautious and move slow. Anything I do wrong usually has more far reaching effects than something a...
January 25, 2002 at 10:08 am
Mind updating us? It's nice to have a followup so others who search these forums can see the resolution.
Steve Jones
January 25, 2002 at 10:02 am
There shouldn't really be much overhead. There will be security checks, but I prefer a second database for two reasons. Performance and Backups/Restore.
If you have a failure in the db...
January 25, 2002 at 10:00 am
I'd pipe the output of the execute results task to a file and search it. This is probably the best technique, though your search routine may be cumbersome.
I did a...
January 25, 2002 at 9:51 am
Yikes, I hate triggers. If you must, Brian's suggestion is easier, but ift may come back to haunt you if the requirements change.
Steve Jones
January 25, 2002 at 9:42 am
Viewing 15 posts - 38,206 through 38,220 (of 39,456 total)