I'm sure this isn't the best way.. but you could build your sql into a string and pass the sort type (ASC or DESC) as a parameter and then execute...

Things didn't work out quite well enough for me with the synonym thing

i created my synonyms, but I could hit the occasion where the same stored proc should hit Db2...

Thanks guys..

the synonym thing looks like it has legs..

I'm gonna have a play 🙂

Thanks.. that makes sense I guess.. as I wont know the user login information, if its not there, I'll just return a message to that effect.

Here's my code in case...

hmm.. hate to be a pest.. but.. I'm trying to set this up so it'll try and Autofix every orphan user..

Heres what I have:

CREATE TABLE dbo.temp_OrphanUsers

(

UserName varchar(250) NULL,

UserSID varchar(500) NULL

)...

that seems to be just what I was looking for.. just need to wrap the Report and the Autofix together and it should be a winner.

Thanks for the help 🙂

Thanks Lori, that did it..

Still odd though.. at one point i had DBWMS002_old up and running right next to DBWMS002_old (Restoring...)

But, I wont worry about it anymore..

Thanks everyone for your...

i did restore as a different name, i did the restore by right clicking databases and picking restore.. i dont recall if i had norecovery on or not.. i really...

Thanks a bunch.. that makes sense

use the sql server agent to schedule the job..

and you could use a modification of:

http://www.sqlservercentral.com/articles/Advanced+Querying/tippipequery/175/

personally.. i'd output to another table in the database but thats just me.. i hate working...

Kishore.P (11/10/2008)

---

do all types of validations at front-end, this is one of the best validation, validation like length, datatype, etc.

If any error occurs, the identity column increment the value.

Otherwise, in...

I changed the SQL Server and sql agent to run under a domain account that has administrative rights to the machine im trying to run the exe's on.. no change...

Thanks Elisabeth

I don't want to do it on a trigger.. once a minute will be fine, i'm looking for set rows that match a certain status. sounds like my...

thanks gail.. that makes sense i guess.. and it wasn't really a problem... just struck me as weird..

thanks again

Thanks!