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 :- 0xD11F59A19F9B944FBD59D6A534F0D067 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...
Hi, I have a table with the following formatt:- GUID Uniqueidentifier Prod Char 20 Blob text Date datetime. When I merge...
yep
Hi Guys, 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.