Making column identity is an option that should have thought beforehand. If we go that route now, it can mess up reports and other files that we already sent to...

This works perfect. Can you explain what this is doing? I'm new to cross apply.

I mean this type of alert.

Attempt to fetch logical page (1:14894525) in database 10 failed. It belongs to allocation unit 16662986752 not to 72057610700914688

It actually said

CHECKDB found 0 allocation errors and 0 consistency errors in database 'Database'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Does this mean I'm good? Why...

Yes. Whats happening currently is that expression is calculated in a view. Those tables are large OLTP tables and only the subsets in view. And there are so many other...

Thanks. Would putting this case in the where clause slow down the query?

What would be the ideal way to do this then? Haven't encountered data integrity yet. But there could be.

After waiting for a while, I was able to detach the db, rename the log file and then attach it back without the log file. This took care of it....

Can I do this when db is online?

How? I tried to issue

ALTER DATABASE MyDB

SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Its giving me following error message.

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.

Msg 5069, Level 16,...

Its a IBM third party tool CDC that replicates data from ERP to SQL server. I tried to one of the method listed in SSC.com. Detach, and reattach without the...

Does this also carry over the appropriate permissions on the dbs?

For new packages and old packages; package will reside in MSDB. I am trying to avoid RDP access to users to logon to server and deploy that way. I haven't...

Anybody?

Yes it is 32 bit instance.