Thanks for your prompt response

Regards

Balaji G

alvirochka (11/22/2010)

---

I am using SQL Server 2008. There are two Servers: 1)Active Server "Server1" 2) Server for storing not important data or old data "Server2".

What the best way to...

Hi,

Once you delete the 15 million records from that table. then you cannot reuse the unused space and also the db size will not be...

John Paul-702936 (11/16/2010)

---

when i am try to use add link server which is 2008 from machine 2000 ,

sp-addlinked server [2008Machine].. worked fine .. i can...

Hi..

how many tables are there in corruption db..

if you are access the query analyzer in corruption db & if its less..

then you can write a insert query for the following...

Hi Winash,

Thanks for your reply...

As per Geoff instructions, if i changed the objects owner from user schema to dbo schema

...

Geoff A (10/15/2010)

---

your login is not synced with the old 2000 DB.

you can access the 2000 DB by either using you current 2008 sa or any login that is a...

Cath Trimble (10/11/2010)

---

Have you tried registering the Activex Script Host?

Instructions here: http://www.sqldts.com/224.aspx%5B/quote%5D

Hi Cath,

I had registered the following dll file into my client machine.. but...

Hi Reo,

This is for a childish question. but i don't know.. how to find out schema for all sql objects in sql2000 and sql 2008.

if its...

Hi,

while i'm restoring the database.. its just created the users and not to mapped the permissions.

So in our...

Thanks a lot. Gail

Regards

Balaji.G

Hi Gail,

I checked my instance details. I have list out here

APRST2008\sqlexpress(sqlserver 9.0-4053)

Microsoft SQL Server Management Studio 10.0.1600.22...

Thanks for your valuable post Gail

Regards

Balaji

Hi Gail,

Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20

Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6002:...

crazy4sql (9/27/2010)

---

the account you configuring in security tab, you need to be make sure that account have requried...