Viewing 15 posts - 34,216 through 34,230 (of 39,728 total)
what do you mean it can see the SQL Server? You can log in? If you can log in, SP2 has nothing to do with it. It would be a...
January 2, 2005 at 11:17 am
I'd use the Apex tool or another as documentation is best done by a tool.
January 2, 2005 at 11:15 am
Just insert permissions
set identity_insert mytable on
insert mytable (myidentity, myvalue) select @myid, @myval
set identity_insert off
January 2, 2005 at 11:14 am
charindex or patindex can help you find the commands and then substring can help you split them out.
I wrote a series on working with strings that might help you
http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp
http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp
January 2, 2005 at 11:13 am
nchar consumes two bytes as well. Do you mean convert to varchar instead? In SS2K, above 4 or 5 char, it doesn't make sense to use char.
January 2, 2005 at 11:10 am
Vas has a good explanation, but this can be cumbersome to setup and administer. Be sure you spend lots of time testing and build some good tools to handle the...
December 31, 2004 at 10:14 am
sqldiag might do this. It's installed with SQL Server.
December 31, 2004 at 10:01 am
You can have multiple parameters, so I'd pass each item in as one call to the stored procedure and handle that in the code. At the end, you can call...
December 31, 2004 at 9:54 am
I like Jeff's suggestion, but I might also add another job to check and be sure the first one is sitll running.
December 31, 2004 at 9:49 am
Schema bound means the view is bound to the current schema of the underlying tables and you cannot change them. But I agree with jeff, to improve performance, be sure...
December 31, 2004 at 9:38 am
If you are using ADO, there are methods to move between the result sets.
December 31, 2004 at 9:31 am
AJ's method will work fine, although you might want a check to trap errors on the chance your int value exceeds the max smallint value.
December 31, 2004 at 9:28 am
There are 3rd party products like Protegrity to help with this.
December 31, 2004 at 9:25 am
Is the role in sysusers? Are there child rows in syspermissions?
December 31, 2004 at 9:23 am
Apologies for this. I have censored the post
December 29, 2004 at 8:48 am
Viewing 15 posts - 34,216 through 34,230 (of 39,728 total)