Viewing 6 posts - 1 through 6 (of 6 total)
No input at all?
April 27, 2009 at 7:09 am
Sample database code:
alter database test set trustworthy on
create assembly Messaging
authorization dbo
from 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Messaging.dll'
with permission_set = unsafe
go
-- version 2
create assembly [nsSqlMsmq] from 'C:\tempsSqlMsmq.dll'
create assembly [nsSqlMsmq.XmlSerializers.dll] from 'C:\tempsSqlMsmq.XmlSerializers.dll'
-- Create procedures
create PROCEDURE uspMSMQSend
@queue ...
April 21, 2009 at 3:42 pm
Sample code sending xml message to msmq from stored procedure:
public static void Send(SqlString queue, SqlString msg)
...
April 21, 2009 at 3:40 pm
I'm having the same problem.
If i'm reading this correctly, I would run the restore like so,
RESTORE DATABASE Northwind
FROM DISK = '\\server\c$\filename_20051116.DIF'
-- WITH FILE = 1,
GO
I've tried it with the "with" clause...
November 17, 2005 at 2:57 pm
found something.
MOM - Microsoft operations manager
Haven't made any changes to sql server or MOM monitoring around the time this started, but noticed a time pattern. Every 30 minutes @ :25...
August 1, 2005 at 10:02 am
what additional info can I provide.
the connections are starting to mount up. They were just over 200 last night now over 260. All with basically the same spid record set...
August 1, 2005 at 8:18 am
Viewing 6 posts - 1 through 6 (of 6 total)