Forum Replies Created
Viewing 15 posts - 37,801 through 37,815 (of 39,456 total)
-
RE: Enforcing Uniqueness using UDF
Doesn't appear to like functions in the constraint. Either ignored or always fails.
Tried some variations:
1. Reverse logic
2. Change to char() and return the email in the function, check that the...
-
RE: error about permission of sp_sdidebug
Some things I found:
From Neil Pike:
Q. What does sp_sdidebug do?
A. It is used to turn on or off TSQL debugging. There is no user interface for it and no documentation....
-
RE: Stopping unauthorised used start/stopping sqlserve
you are welcome and it was interesting. Hopefully others will learn as well.
Steve Jones
-
RE: Missing DTS package password
haven't seen anything and don't see a pwd column in the table.
I'll keep looking.
Steve Jones
-
RE: Search functionality
Nah, the search guy probably didn't update his search while we updated the site. Thanks for the catch and we'll get on it.
Steve Jones
-
RE: Downloading data from SQL server to Word Docs
Haven't tried it, but do you really need word? RTF, HTML, numerous other "template" formats would be easier to manipulate.
Steve Jones
-
RE: Jobs fail on test server
When it runs the pacakge, does the VB program load and run the package or call sp_start_job?
Steve Jones
-
RE: Secure database from SA?
use a role!!!!!! don't grant rights to users!!!
http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp
Steve Jones
-
RE: DTS Package execution
Don't think you should have an issue. I have pacakges that run multiple copies of themselves and I code to prevent it, but they both work.
Steve Jones
-
RE: Getting the Most Out of SQL Server 2000's Query Analyzer, Part II
save always works. I use this every day in development. It defaults to "untitledxx", but there is the ability to change that. Have you tried "save as"?
Steve Jones
-
RE: MSSQL 2000. Exam 70-229
I thought my book was pretty good, but I know the complaints are mainly on the first section of the exam. We reverified our questions were similar to exam questions...
-
RE: exam 70-229
Well as the co-author of he Sybex book on 70-229, I have a resource out there in print.
Seriously, I took 229 and 29 and thought 229 was... -
RE: Odd Security Problem in SProc
Could it be the underlying tables based on the data being inserted? Other than that, it seems strange? Have you run profiler to see if there is something you are...
Seriously, I took 229 and 29 and thought 229 was...Viewing 15 posts - 37,801 through 37,815 (of 39,456 total)