Well, if the log reader's missing/deleted that would explain the problem with the log. It's definitely a transactional replication, not snapshot.

Can see that from the Replication Type column in...

That's not what I'm talking about. I'm asking if getting your hands on the answer sheet for the upcoming exam that contains the questions that you know will be asked...

You have transactional replication there, not snapshot. Check that the log reader agent is running.

It should be a job, you should also be able to see it from enterprise...

Do you have regular log backups running?

See - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

Probably because of the affect they have on queries. Bad cardinality = bad query plans = higher than expected IO and CPU.

Tomm Carr (9/8/2008)

---

There must be a way to get IntelliSense to update its internal data structures that contain the layout of a table, but I have searched the documentation...

So, if you obtained the question and answer sheets for an upcoming college/university exam and used those to prep for the exam, would that be cheating, or smart work?

An existing table, or a hypothetical table?

Please don't cross post. It jsut wastes people's time and fragments replies. Many of us read all the forums

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic565566-8-1.aspx

Check the windows event log, see if you have any drive errors. SQL doesn't corrupt its own files.

If the problem keeps reoccurring, I would suggest you move the DB...

SQL should run under a non-administrative account. It's a security best practice.

Create a domain account for SQL. I would suggest that you se the domain account so that it does...

GSquared (9/5/2008)

---

I moved a database just last week just using the Alter Database commands, and the files ended up where I wanted them. Of course, that was tempdb, which...

If there's no chance of overlap (which sound like there isn't in this case), that should be union all. Union means that SQL will do a distinct sort of the...

You can write your stored procedures so that they reference tables in both databases. Or, if the developers are beiong lazy and writing ad-hoc SQL code, they can use 3-part...

Because an order by is only valid in the outermost select statement. It can be used within other blocks, but then must be a part of a TOP n, where...