Viewing 15 posts - 3,796 through 3,810 (of 7,636 total)
Hmmm, I ought to know this one...
Try changing your queue setup to "EXECUTE AS OWNER".
January 20, 2009 at 4:03 pm
Please post the exact error message here, and tell us where you saw it.
Also, please post the activation procedure, as I am pretty sure that that is where this is...
January 20, 2009 at 2:34 pm
Do the following:
1) Check to see that the Queue and the Activation procedure are still enabled (Service Broker will turn them off in "poison message" situations).
2) Check your SQL Server's...
January 20, 2009 at 1:49 pm
jcrawf02 (1/20/2009)
Wise choice. The Estimated Execution Plan for your Life Optimizer was veering dangerously close to a cigarette, a blindfold and a loud bang.Or maybe that's just my experience.
Heh,...
January 20, 2009 at 11:35 am
This earlier thread seems to have a way to do it: http://www.sqlservercentral.com/Forums/Topic348632-291-1.aspx#bm599356
January 20, 2009 at 10:27 am
In what way are any of these better than sp_MSforeachtable?
January 20, 2009 at 10:22 am
raj (1/20/2009)
Your help or workaround to replicate tables having no primary key through P2P replication will be a great help to me.
IIRC, you either need a primary/unique key, or you...
January 20, 2009 at 9:39 am
SOP for this is to use SQL Server Replication to replicate the two table from the new server to the Legacy server/DB as read-only tables there.
There are a lot of...
January 20, 2009 at 9:37 am
mj12 (1/20/2009)
January 20, 2009 at 9:21 am
Are you saying that the second job is not being created?
How are you running this script after the production database is attached?
January 19, 2009 at 8:20 pm
Or, if you insist on using "*" in views, always make sure that there are no fields after it.
January 19, 2009 at 7:08 pm
EIAnd (1/19/2009)
BULK INSERT Temporal FROM C:\Archivo.DAT...
The question is:
Why the archive that have the codes have to be in extension .DAT?? mi files are .txt
No reason that I know of....
January 19, 2009 at 5:41 pm
tom.goehring (1/19/2009)
January 19, 2009 at 3:35 pm
I'll take a look at it if you want, Jeff. Just to see how much of it is about me. 😀
January 19, 2009 at 3:29 pm
Viewing 15 posts - 3,796 through 3,810 (of 7,636 total)