Leaving the database wide open is too risky for me as well. I think you will find...

I like the...

Thanks for the Question.

Profiler is one method. You could also search your stored procs to find any instances of that table.

If code is hitting your database from the application and is not...

If the servername, databasename, and schema are no longer present in the query being sent, then something has changed in the application. I would check again.

Model is the "model" that will be used by SQL Server to create any new databases.

Thus it's importance is "it depends" on your environment. I would place MSDB above...

repent_kog_is_near (3/24/2010)

---

I agree.

one of the DB is just non-confidential info that the company wants to be in public mode so anyone can have access for PR.

I believe that status...

Echoing Jeff here. SSIS is unnecessary to create a maint plan. However, if you have SSIS installed, you can edit the Maint Plan with BIDS. You would...

SQL Reddy (3/24/2010)

---

Do you mean to say what i thought before was correct?

If i have two nodes A,B and two instances X,Y .

If X,Y are running on A ,and B...

Active/Active is having each node in a cluster hosting a differenet sql instance.

http://www.sqlmag.com/article/clustering/active-passive-vs-active-active-clustering.aspx

I agree with Grant, Gus, Lowell, Lynn, and Steve.

Try to answer the questions, browse the topics, test the answers. Testing some of this stuff out is very effective in...

I would start by finding some books. Narrow down the topic by picking a few specific things you want to learn - and then find the answers.

Without the clustered index, no.

For the archiving of the heap tables - do you have a unique key or unique index on the table - could help with the archiving,...

The group will need to have select permission for the tables on the database where the tables reside.

It would be best to assign these permissions to a role and then...

The main difference is that transactional is one way replication (by default). Merge replication is two way replication.