Forum Replies Created
Viewing 15 posts - 37,096 through 37,110 (of 39,720 total)
-
RE: Polling from Enterprise Manager - Authentication
I believe it connects to the IPC$ share or to port 445 to poll the server and see if it is running. Not sure if this would result in an...
-
RE: VPN access to a SQL Server 2000 box...
I know that the default instance, EM uses 445 to connect as well as 1433, 1434. Are you using some redirection with SSH?
Steve Jones
-
RE: programmatically load and execute sql script
be very very careful with this. Like dynamic sql, this is asking for an injection attack.
Is there a reason not to use isql or osql?
Steve Jones
-
RE: Middleware/Business Logic
the gains from a middle tier come (with a well designed app) from offloading CPU cycles from the web server and the sql server onto another box. Like crunching numbers...
-
RE: change the defaults for DTS
Not sure you can. I'd suspect this is in the registry or a cfg file if you can. Most likely it's hard coded.
Steve Jones
-
RE: Backup problem
Most likely the tape is too full and it's not set to overwrite the tape.
Steve Jones
-
RE: Restoring using MDF files
You can attach this without shutting down the server.
Steve Jones
-
RE: extracting current database name
select db_name()
Steve Jones
-
RE: Data and Log File Placement Question
Either that or detach/attach. Raul Sharma has an article on usnig that on this site.
Steve Jones
-
RE: Near Realtime Results
The speed of SS2K is plenty, just depends how things are implemented. There are lots of tricks you can do, use triggers to keep a summary of data current in...
-
RE: Data and Log File Placement Question
Depends on load. For smaller apps, I've dropped everything on the same RAID 5 and no big deal. Nice to separate out, so if you move the hardware later, the...
-
RE: ANSI Options Part 4 - ANSI_WARNINGS
Thanks for the updates. I neglected to test this and didn't see an errata on this.
Steve Jones
-
RE: MS02-048 Certificate Enrollment Control (Critical)
Thanks for the update.
Steve Jones
-
RE: Transaction Log
That should work fine.
Steve Jones
-
RE: How can I read the contents of a file ?
A text file?
xp_cmdshell 'type filename.txt'
Steve Jones
Viewing 15 posts - 37,096 through 37,110 (of 39,720 total)