Forum Replies Created
Viewing 15 posts - 37,156 through 37,170 (of 39,769 total)
-
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
-
RE: Running XP_CmdShell
On the SQLAgent proerties box, there is the place for a proxy account, which will be the account under which xp_cmdshell runs.
don't forget xp_cmdshell is in master, not another db,...
-
RE: find record
Is the number a column name or in a row in the table? If it's in a row, is it always in the same column name?
Steve Jones
-
RE: One VB App does not show in Profiler-Weird!
the client has to send this. Check the client app settings for ODBC or whatever conneciton method you have.
Steve Jones
-
RE: SQL Mail and Voting Buttons
You could probably build htis programattically using DTS, aCtive X task and some outlook controls. Or even a custom control.
We use voting buttons here. I'll try to look at this...
-
RE: SQL Mail and Voting Buttons
You could probably build htis programattically using DTS, aCtive X task and some outlook controls. Or even a custom control.
We use voting buttons here. I'll try to look at this...
-
RE: SQL-DMO for Beginners
Thanks both of you. And I agree. I should rename the controls, even if this is the simplest form
, I may reuse it. And may want to... -
RE: Need help with data import
There are some beginner articles on DTS. I'd start there. Create a text file conneciton, select your file and use the "properties" to verify this works.
Then add a SLQ connection...
-
RE: Permissions per Record - best practice?
2nd vote for Brian's explanation.
Steve Jones
-
RE: .MDF and .LDF Size
sometimes logs don't shrink well. There's a script in our library to help do that.
Steve Jones
-
RE: Managing SQL Server 2000 Standard Logons
You can also script your own sp_password that would run after 35 or so days to lock out users.
Steve Jones
-
RE: SQL Server 2k: Know if collation sensitive or not
This is the reason you DO NOT go into the system tables. They change from version to version.
Better to use the sp_helpsort and parse the string. It will work...
Viewing 15 posts - 37,156 through 37,170 (of 39,769 total)