Paul White (9/9/2009)

---

I see. ARe you able to rename the file from Windows explorer? ...

Wayne (9/9/2009)

---

Hello all,

I need to create a huge table (more than 500 million rows and 50 columns) in SQL Server. One of my coworkers told me that I should split...

Trooper (9/9/2009)

---

I have a maintenance plan which takes the db in to simple recovery model , rebuild the indexes , and then get it back to full recovery model.

The step...

This is the test reply 😛

jfn (9/9/2009)

---

I am looking for the means to list out the tables in the SSIS packages I have. I can find the tables on the system but do not know...

ramyours2003 (9/9/2009)

---

as a dba's job r they decomissioning the server , if yes explain the steps for decomission the server and what are the preventive steps need to be...

Do I have to, I was very comfy lying...

sounds like you dont have full permissions to do the install.

J.D. Gonzalez (9/9/2009)

---

Thanks for the query. Exactly what I needed.

Turns out the login in question was set at the owner of the DB. It seems that by giving...

that is too generalised a question, if you can be more specific...

mattaustin (9/9/2009)

---

Hi All,

We're having a problem with an upgrade from SQL Server 200 to 2005 that hopefully someone can offer some advice with?

Our 3rd party software connects to the database...

Tara (9/9/2009)

---

I have a script which i want to run from the same stored procedure which locks some tables in the database which contians sensitive data.

Can you let me know...

paucann (9/8/2009)

---

Hi,

I'm writing a web service to be consumed by a Silverlight proj.

I'm getting the error above even though I can connect to the server and database through SQL Server...

Amit Singh (9/9/2009)

---

Has anybody seen or practices the concept of NOT installing Books Online on production servers ? I have always installed books online on production servers and have found...

runaldo (9/9/2009)

---

1) When installing named instances a random portnumber is applied (Dynamic port).

2) When accessing try with creating an odbc. On large networks telnet is often denied.

3) If you...