We have free medical here in the UK too, called the NHS. But it mens waiting a long time, before getting seen.
Its the same but does not you a curser.
The entities should be your database name.
did u ever figure this out?
I have the same problem now
How about this?
declare @SQLText varchar(8000) ,@spid int
select @spid = min(spid) from master..sysprocesses where dbid = db_id('Entities_Copy')...
Thats done it.
Thanks a lot
Hi I have a binary(16) variable called @BinName it stores a vaule of :-
I want to be a ble to see this in a...
Yes but any one know of a way of giving a user rights to view jobs, with out sysadmin.
I am guessing there will be a sp in msdb?
I found the answer, was a relly simple one but so easy to miss. I had not set the coloum to be incrimented. Using the following
will do this:-...
Thanks for you help guys. But I have checked all these settings. The set up is the same on both sides. With the newist sp. (sp4). I have made...
I have a table with the following formatt:-
Prod Char 20
When I merge...
I have some jobs running on a server that every now and then take a lot longer to run that they are ment to. I am looking to find a way of...
Separate names with a comma.