Make sure that there are no connections to the database before shutting down the SQL Services, do this via sp_who2 active

Make sure that there are no backups etc running.

That should do it

Remember though, this is predicated on the fact that you have no constraints on the tables you want to delete. Foreign Keys etc...

Perry Whittle (10/12/2011)

---

what is providing your shared storage for your cluster, do you have a SAN or some other NAS?

Do you have a storage administrator, someone who looks after said...

SQLTestUser (10/6/2011)

---

thanks for the script, I did get the answer i don't believe there is any way we can delete multiple tables( the whole table with the contents in it,...

Perry Whittle (10/12/2011)

---

To be honest i would just go for this

1. On Node B: Add the required roles and features to enable for failover clustering

2. On Node A: Run the...

Perry Whittle (10/12/2011)

---

derekr 43208 (10/12/2011)

---

Perry

I'm quoting from your SSC article "Creating a 2 Node SQL Server 2008" - In the beginning of Part 3 you mention: "the Windows 2008 cluster...

Perry Whittle (10/11/2011)

---

That's exactly what it does. As i mentioned previously, ensure the node is added to the Windows cluster first...

Perry Whittle (10/11/2011)

---

That's exactly what it does. As i mentioned previously, ensure the node is added to the Windows cluster first...

Perry Whittle (10/10/2011)

---

derekr 43208 (10/10/2011)

---

Hi Guys

I have SQL 2008 enterprise Sp2 installed on Windows 2008 enterprise.

This is a single node cluster

What is the process of adding a second node to...

- Index maintenance on something this large - how long could it take (luckily we will only have to do it once a month).

- Any rules of thumb for how...

You could write a query that goes through Information_schema and creates a drop table script

Something like:

set nocount on

select 'DROP TABLE '+table_schema+'.'+table_name+'

GO'

from INFORMATION_SCHEMA.TABLES where TABLE_NAME = ''

This is assuming you have...

Thanks all

Thanks tested but doesnt work

This is the result:

(18 row(s) affected)

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'GO'.

Msg 102, Level 15, State 1, Line 6

Incorrect syntax near 'GO'.

Msg...

Thanks

Thanks Gail!