My table has 2 columns;

Name & text

Name = the proc name

Text = the create procedure script - so in the mess below (text column) I would like to extract all...

thanx. When i do a like statment it brings back the entire string, which I know is correct. What I am hoping to do is just pull out...

Problem was with SPN's, solved now

I got it. I was just being daft. Thx!!!!

Thank you. And if I have multiple rows, how do I only test those conditions on the very last row for each order ? If I have rows...

Thanx Mike.

Profiler showed that someone created a view in another database over the replication tables.....hard to explain what I mean, even harder to understand why someone would do something like...

The account used to drop the service on the remote server is a non-sysadmin. But when I execute the .bat on that server with that acct. all is well.

I...

I need to stop the service to do the restore. This application, Warehouse Management System, keeps the services running & if I kill these connections to the sql server,...

I am actually trying to stop a service on a remote server to do a restore on the sql server. I found psservice & downloaded it & it works...

OOPS!!! Sent the "You Rock" thanx so much to the wrong thread....but you do, so I'll say it again, YOU ROCK!!!

You rock!!! Thanx so much for your help!!!

One quick question on running that update script, this problem is on an instance & the base instance is working fine. Will running this script have any impact on...

Ok, so the exception error is no longer present, but now it says mail configuration information cannot be read from the database..timeout

Thanx.....port 25 is enabled, still throws the same error. Can I stop/start the instance without affecting the base instance? Does that even make sense to do? I...

Thanx again.

I tried everything you suggested & when I use script it goes to "mail queued", but looking in the log the exception error message I posted earlier is still...