Viewing 15 posts - 571 through 585 (of 1,790 total)
Sorry, thought the error was being generated when applying the snapshot. I haven't replicated stored procedures yet so, haven't really run into anything like this. Sounds like your initial thought...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 27, 2009 at 10:13 am
On the publisher in the published database can you run select * from syspublications and post the output here.
On the subscriber in the subscription database run select * from...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 27, 2009 at 9:47 am
Is the UserDefinedTableType at the subscriber? What if you were to put that on the subscriber first then try to run your snapshot again?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 27, 2009 at 9:39 am
First - I apologize for the late reply on this. I am in the middle of a significant upgrade project and probably shouldn't have even started on this thread. :(...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 2, 2009 at 7:49 am
You can download a great free E-Book by one of the forum posters on this site, Grant Fritchey. Check it out HERE.
A shameless plug for a great free resource. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 2, 2009 at 7:43 am
What is the lastwaittype that is in sysprocesses for the spid in question when it is blocking itself?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2009 at 12:06 pm
A quick query to get that;
select object_name(ic.object_id) as object_name, i.name as index_name, COL_NAME(object_id('Sessions'), ic.column_id) as column_name
from sys.index_columns ic join sys.indexes i
on ic.index_id = i.index_id
where ic.object_id = object_id('Sessions')
I'm sure...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2009 at 11:50 am
Did you use rebuild or reorg? Rebuild will take care of stats reorg will not.
Certainly not making the case that this is emphatically the issue but in most cases...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2009 at 11:38 am
How are your indexes and statistics? Next time you see this come up take a moment and update the statistics on the most heavily used (inserts / updates / deletes)...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2009 at 11:31 am
A lot of the code is sourced from another script posted by another user on the site. I reference the original script when I posted my version so that proper...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 31, 2009 at 3:21 pm
I would highly doubt that there is a way to change this. Can you explain what you are using this for? My guess is that you are going to have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 21, 2009 at 8:32 am
You can't necessarily see what is scheduled unless you review jobs / maintenance plans. You can however review history by looking at the backupset table in msdb. Check out Books...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 21, 2009 at 8:28 am
You can use the tablediff utility provided with SQL Server. A introductory article can be found HERE. You can also look it up in BOL.
Another, and easier, option is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 21, 2009 at 8:22 am
Understood. If you find a way be sure to post it here. 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 22, 2009 at 11:12 am
This query which I pulled from HERE (I'm pretty sure this is where I got it anyway) will get you most of what you are asking for I believe.
withxmlnamespaces...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 22, 2009 at 8:58 am
Viewing 15 posts - 571 through 585 (of 1,790 total)