Server: Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (1:399191). The PageId in the page header = (0:0).

Server: Msg 8909, Level...

We ran dbcc checkdb against all databases on that server and found one more database which had acquired similar issues. 2 data pages belonging to 2 different tables were damaged....

Oh Yes. Thanks for correcting me Lowell. In such case we dont need to create a linked server.

Glad you got it working.

did you schedule the job to run at specific intervals or manually ran it once? I suggest u schedule it at regular intervals (may be off-peak...

If you need to know which table was accessed by whom and when, you can write a server side trace (keep in mind that it will be resource intensive) and...

syedtameem11 (6/30/2009)

---

Hi,

I want to use triggers to make changes to another database after we insert or update a record. The table name is same

for ex. FIELD_EXECUTIVE_DETAILS table there in Test1...

raveen4u (6/30/2009)

---

I have 2 tables Dept & Employee. DeptID is refered from Employee.

The structure is like this

DeptIDPK

DeptName

EmpIDPK

EmpDepFK

EmpName

"Select DeptName,EmpName from Dept,Emplyee Where EmpDepFK = DeptIDPK"

This query gives...

Sales Jack

Sales...

Hey Guys, pls dont laugh at me but i was happy today to find myself amongst top 100 forum posters.:-D

Learnt lots from this site which forces me to stick here...

ps (6/30/2009)

---

your log reader agent must be running continously or at specified intervals to read the log of the published database and bring 'changes' to subscribed articles to the distribution...

Neerav (6/30/2009)

---

hi lowell,

At least someone is agree with me..Thanks Bro!!!!

We have OLTP system.can you send me some Performance tuning tips because at certain point our db slow down.

we dont have...

your log reader agent must be running continously or at specified intervals to read the log of the published database and bring 'changes' to subscribed articles to the distribution database....

jabba (6/30/2009)

---

I am currently trying to determine where some of our databases were last accessed as part of a cleanup operation.

I am currently using the sys.dm_db_index_usage_stats, in particular the...

Please go through http://msdn.microsoft.com/en-us/library/ms186865(SQL.90).aspx

and let us know if you still have confusions.

I suggest you initialize your subscription from a full backup of your production database, this wont consume resources on your production db as compared to generating a snapshot where a...

Interview Questions?