Can I backup to a non-local drive? Obviously, using T-SQL could be different, but when testing with E.M., I could not specify anything that was not on the local...

The reason for this trigger is this: the project I am working on has many independant databases running on various client sites. A communication process in the application...

what a difference a Subject line makes... SO, now that I have "read" my own post 10 times, and only two other people have looked at it, I will...

now that's some good crap there. I forgot that you can spy on SQL Server to see how it does those sp_'s

Thanks Antares.

another elementary question, I'm sure, but how would you then capture and inspect the results of the SP?

Thanks

P.S. I should clarify, that I'm attempting to do this in a...

bummer. AND, I can't use an "Insert @TableVariable EXEC SP..." Why can't anything work the way I'd like it to? So, I guess I'll make the temp...

frustrated again.... So, I set out to store my SP results in a table variable (because of all the woderful things that BOL says about them), and have discovered that...

well, I hate to say it, but I wanted a function that could be used within a recursive Stored Procedure - returning a different value or table each iteration.

me thinks you did not try my first suggestion...?

>> (field1<>'B' or field2<>0000)

jpipes response is probably more understandalbe, but mine is shorter. and...

try (field1 <> 'B' or field2<>0000)

this may never work, but just for kicks, have you tried breaking your query into multiple strings (varchar variables). I belive there is like an 8K limit on the...

hey folks, thank you for your various responses. As I had aluded to earlier, the problem here turned out to be with the difference in the way Sybase and...

hey folks, thank you for your various responses. As I had aluded to earlier, the problem here turned out to be with the difference in the way Sybase and...

your confirmation is all I need. thanks. moving on...

borrowing from 5409045121009's script, and using the DATABASEPROPERTYEX function to check my ANSI_PADDING setting, here's my test script:

select DATABASEPROPERTYEX('ISIS_PRO' , 'IsAnsiPaddingEnabled')

go

Create Table Testing(A varchar(10) not null,B varchar(10) not null)

go

CREATE UNIQUE...