cindy_sinath (11/9/2008)

---

I am trying to perform a Count on the same field to spilt the data up into two sets, Tests and Sessions

SELECT Count(Lesson_CatId a) AS October_Total_Test, Count(Lesson_CatId b) AS...

This is good for a basic start. I would simplify this a little - for example, I would change the dynamic query to the following:

EXEC sp_msforeachdb 'Use ?;

INSERT INTO...

You need to lookup in Books Online the topics 'Recovery Model' and Backups. Basically, what you need is:

o Database in Full Recovery Model

o Daily Backups (2am)

o Hourly Transaction Log...

Matt Miller (11/7/2008)

---

Are you SURE you have SP2? As best I can recall, those thing didn't show up until SP2. I'd reapply/reinstall my client tools, and then repatch...

If you are running Enterprise Edition - you can use a database snapshot. As long as the snapshot is refreshed on a regular basis, you could then read the...

Another option (which will require a downtime) is to:

1) Perform a transaction log backup (tail log)

2) Restore your latest backup

3) Restore transaction logs to point in time...

Those services don't have to be on that server - can be on the web server or a separate application server. If you are seeing connection attempts every few...

Yes, that is correct - if you are restoring master then SQL Server needs to be in single user mode.

You can try looking in the default trace for the delete event for that table.

Here is an example query:

Select *

From fn_trace_gettable(@default_trace_file,Default)

Where EventClass In (46 ,47)

...

Check for any application services that are trying to reconnect to SQL Server. Disable those services to prevent them from trying to log in.

However, are you sure you need...

Unfortunately, I have absolutely no clue as to why this is being done. Are you really calling a procedure in one database, that needs to access data in another...

Sorry - still doesn't help. If the users are executing a stored procedure - then it should not matter what objects are accessed by the procedure.

The only time it...

John, sorry - but this question does not really make any sense to me. You cannot have a stored procedure that has a USE statement in it.

Second, why would...

And, just to confuse the issue some more 😉

ANSI standard quoted identifiers is the double-quote - so, the following will work also (as long as you have not disabled quoted...

GilaMonster (10/31/2008)

---

Bob Bridges (10/31/2008)

---

One thing I'm not absolutely clear on though... you mentioned the "daisy chain of logs" in recovery. If I have a full backup every night and have...