Is your SQL Server 2000 DB engine still running?

If so, I would first stop the DB engine and check if there is any impact ( Incase any apps are...

Gail, any corrections / suggestions to my method...

I am not sure if this is a suggested method, but I am giving what's on top my head.

You cannot rollback changes only to a single table, rather to a...

CirquedeSQLeil (12/10/2009)

---

Back to the lock pages thread

GilaMonster (12/10/2009)

---

If you have Standard edition of SQL 2000 then this entire conversation has...

I wonder would you ever use Google 😉

Where are you using varchar(10) and smalldatetime, I dont see the DDL stmts.

But yes, you can use Varchar(10) to store in the format that you wanted to.

Feels like 24⁰ F with gusty winds around 30 MPH

mr_adeelalisyed (12/10/2009)

---

Hello experts,

I’m having a little challenge in updating one of my table. I’m trying to capture create_date from sys.databases. when I try to update my table using the following...

Are the questions really worthy of asking.

Someone who has worked at least once with SQL 2000 would surely know how DTS packages can be created and if you worked...

Replication is by default disabled (not configured), you may try to find out the servers where replication is configured, may be a documentation or a write up.

Question about impact...

Nice Marmot (12/10/2009)

---

Hi,

The version of SQL Server you are restoring on to has to be the same or higher than the source version. Install any updates first.

I haven't...

Lynn Pettis (12/10/2009)

---

Bru Medishetty (12/10/2009)

---

ray 78019 (12/10/2009)

---

Hi Greg,

If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different name, it'll...

ray 78019 (12/10/2009)

---

Hi Greg,

If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different name, it'll still be saved as...

Is this on a production system? Just don't want to cripple your prod boxes.

Can you try reconfigure distribution this time choosing a different location for the ReplData.

Of course, if you...

schauhan13 (12/9/2009)

---

Solution:-

SELECT COUNT(*) AS Expr1

FROM (SELECT partnbr

...