Are you saying that the snapshot completes successfully but then replication stops after three hours?

If you are saying that, is it exactly three hours every time?  Have you checked the...

If you're looking for point-in-time, save your trace to a table called TraceTable and run this:

declare @PointInTime datetime

select @PointInTime = 'June 16 2006 10:55:49.890 AM'

if @PointInTime < (select...

Yelena

Are you looking for the maximum number of concurrent connections during a period, or the number of concurrent connections at a specified point in time?

John

Erde

Is it possible that when you hit 2090000 rows, your data or log file fills up and has to autogrow?  If it is set to grow by small increments then...

Paul

Here's a solution that doesn't use a numbers table.  It will work in your situation but it may be fairly difficult to generalise!

First off, I assume you have a constraint...

Jeff

This (and other similar threads) seems to suggest that there is logging in tempdb.  Don't know whether there's anything from Microsoft confirming this.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=13898&p=2

John

I'm not sure that this is the neatest or easiest way of doing it, but it should work:

(1) Using Enterprise Manager, create a job called something like "Event Notification 322"

(2)...

Sandesh

Try putting an N in front of all quoted text.  Make sure that all variables have been declared as nvarchar.  And get rid of those unnecessary qualifiers - that will...

Jonathan

Check the properties of the task and make sure you're not copying any users or logins.  It sounds as if SQL Server is having difficulty copying a user or login...

I don't understand what you're asking.  You can see the restored database under Databases in Enterprise Manager (you may need to refresh) and you can see the backup file in...

(1) If the database already exists on the destination server, make sure that nobody is using it and then right-click on it in Enterprise Manager.  Otherwise, right-click on Databases.

(2) Choose...

Sandesh

Again, have your SP print the SQL it's going to execute.  It'll be a lot easier to debug that way.

You don't need to qualify every mention of a column with...

This should do it:

select b.close_price, b.date, c.avg, c.year

 from tenyearbond b

 inner join cpi c

 on datepart(year

You have a lot of dynamic SQL in that stored procedure.  For troubleshooting purposes, try adding a PRINT statement before every EXEC statement so that the SQL that is about...

David

Not sure exactly what you're asking for, but here's a guess:

insert into MyDB.dbo.Abs (Tpc, Prp, Frwk, Fndgs, Title, Mthds)

select Tpc, Prp, Frwk, Fndgs, Title, Mthds from BackupDB.dbo.Abs

John