How I can undo drop Table ?

Hello:
Please, I need Help. I have an Access database linked to SQL Setver 2000
tables.
I delete the tables from Access. I inmediately stop Sql Server. I need to
restore the tables. How can I proceed ?
I really will appreciate any help .
Roberto
Roberto Carabajal wrote:
> Hello:
> Please, I need Help. I have an Access database linked to SQL Setver
> 2000 tables.
> I delete the tables from Access. I inmediately stop Sql Server. I
> need to restore the tables. How can I proceed ?
> I really will appreciate any help .
> Roberto
You'll need to restore the database from a backup file and then restore
any log files. If you are using a recovery model other than Simple, you
may be able to recover the table using a tool like Log Explorer from
Lumigent (but you'll need to purchase it).
There is no undo operation for things like this.
David G.
|||Restore from a backup. There is no built-in feature to undo deletions of
objects.
David Portas
SQL Server MVP
|||Hello Roberto
The table/data may be unrecoverable if the following are true :
- Command was not run within a transaction
- Command completed before SQL Server service was stopped
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Do you mean you deleted the link in Access? If so, relink the table.
Deleting the link in Access will not drop the SQL Server table.
If Access is the linked server in SQL and you deleted the Access table, you
may be able to restore the table if the Access DB has not been compacted
since the deletion.
Kevin
"Roberto Carabajal" <RobertoCarabajal@.discussions.microsoft.com> wrote in
message news:DDFEECBE-2FE5-43C6-B30A-FA887A99E92A@.microsoft.com...
> Hello:
> Please, I need Help. I have an Access database linked to SQL Setver 2000
> tables.
> I delete the tables from Access. I inmediately stop Sql Server. I need to
> restore the tables. How can I proceed ?
> I really will appreciate any help .
> Roberto
|||I delete the table in Access tables's view, but the table was linked to Sql
Server, so the "real" table resided in Sql Server.
Thanks very much anyway.
"Kevin Doyle" wrote:

> Do you mean you deleted the link in Access? If so, relink the table.
> Deleting the link in Access will not drop the SQL Server table.
> If Access is the linked server in SQL and you deleted the Access table, you
> may be able to restore the table if the Access DB has not been compacted
> since the deletion.
> Kevin
> "Roberto Carabajal" <RobertoCarabajal@.discussions.microsoft.com> wrote in
> message news:DDFEECBE-2FE5-43C6-B30A-FA887A99E92A@.microsoft.com...
>
>
|||I'sorry. I should clarify it is an .ADP proyect used as a tool to managing
the server.
The problem was that droping table from the project <=> drop table in the
server.
Perhaps, it could be a "undo" in the proyect, but I must admit Access never
had similar one.
"Roberto Carabajal" wrote:
[vbcol=seagreen]
> I delete the table in Access tables's view, but the table was linked to Sql
> Server, so the "real" table resided in Sql Server.
> Thanks very much anyway.
>
> "Kevin Doyle" wrote:

How I can transfer login and password between SQL7 and SQL2000 Ser

Hi Good Day to everyone
In SQL7 Server have created some users ID with the passwords. I would like
to know how I can transfer those login IDs and Passwords into the SQL2000
server without re-create.
Besides, I would like to how to change the db ownership after I transfer the
ID and password?
Please advise.
Polar Bear.
* Polar Bear is new to SQL DB
Here are some articles you may be interested in:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Polar Bear" <PolarBear@.discussions.microsoft.com> wrote in message
news:D76B2259-BEA3-4239-9BBB-2E24A2395DBC@.microsoft.com...
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer
> the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB
|||Check out http://www.support.microsoft.com/?id=246133 for transferring
logins.
With regards changing the database ownership, check out SQL Books On
Line for the sproc sp_changedbowner.
Regards
ALI
Polar Bear wrote:
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB

How I can transfer login and password between SQL7 and SQL2000 Ser

Hi Good Day to everyone
In SQL7 Server have created some users ID with the passwords. I would like
to know how I can transfer those login IDs and Passwords into the SQL2000
server without re-create.
Besides, I would like to how to change the db ownership after I transfer the
ID and password?
Please advise.
Polar Bear.
* Polar Bear is new to SQL DBHere are some articles you may be interested in:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Polar Bear" <PolarBear@.discussions.microsoft.com> wrote in message
news:D76B2259-BEA3-4239-9BBB-2E24A2395DBC@.microsoft.com...
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer
> the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB|||Check out http://www.support.microsoft.com/?id=246133 for transferring
logins.
With regards changing the database ownership, check out SQL Books On
Line for the sproc sp_changedbowner.
Regards
ALI
Polar Bear wrote:
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer t
he
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB

How I can transfer login and password between SQL7 and SQL2000 Ser

Hi Good Day to everyone
In SQL7 Server have created some users ID with the passwords. I would like
to know how I can transfer those login IDs and Passwords into the SQL2000
server without re-create.
Besides, I would like to how to change the db ownership after I transfer the
ID and password?
Please advise.
Polar Bear.
* Polar Bear is new to SQL DBHere are some articles you may be interested in:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Polar Bear" <PolarBear@.discussions.microsoft.com> wrote in message
news:D76B2259-BEA3-4239-9BBB-2E24A2395DBC@.microsoft.com...
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer
> the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB|||Check out http://www.support.microsoft.com/?id=246133 for transferring
logins.
With regards changing the database ownership, check out SQL Books On
Line for the sproc sp_changedbowner.
Regards
ALI
Polar Bear wrote:
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB

How I can to treat a largest table, db?

Hi All,
I have one doubt about largest database, largest tables etc.
For example:
I have one db that have a table with 10.000.000.000 (or more) of register,
and I need get each register and do same thing with it (think that db is
about a credit card and the registers are the transactions of customers, and
I need print the invoices)
If I try use SELECT * FROM. the dm return 10.000.000.000, this is not good.
How I get one by one of table.
How I can to treat (to manipulate) a largest table, db? What are the ways?
What are the tricks?
Can you show me?
Thanks
Hi,
Execute the system stored procedure with out parameters to get the size of
all databases
sp_databases
To get the actual usage of data and indexes then execute the below comand in
the context of a database.
sp_spaceused
For getting the size of table in order:-
select object_name(id) as Table_name,rowcnt as record_count
from sysindexes
where indid IN (0, 1)
order by rowcnt desc
TO get the correct result execute DBCC UPDATEUSAGE (see books online) before
the above select statement.
Thanks
Hari
SQL Server MVP
"ReTF" <re.tf@.newsgroup.nospam> wrote in message
news:OABd$z7aFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi All,
>
> I have one doubt about largest database, largest tables etc.
>
> For example:
>
> I have one db that have a table with 10.000.000.000 (or more) of register,
> and I need get each register and do same thing with it (think that db is
> about a credit card and the registers are the transactions of customers,
> and I need print the invoices)
>
> If I try use SELECT * FROM. the dm return 10.000.000.000, this is not
> good.
> How I get one by one of table.
>
> How I can to treat (to manipulate) a largest table, db? What are the ways?
> What are the tricks?
>
> Can you show me?
>
> Thanks
>
|||that table should have a key, and you should use the key for the record you
want
along with 'WHERE'
it works something like,
SELECT *
FROM bigtable
WHERE thekey = '123'
this will select only one record.
"Hari Prasad" wrote:

> Hi,
> Execute the system stored procedure with out parameters to get the size of
> all databases
> sp_databases
> To get the actual usage of data and indexes then execute the below comand in
> the context of a database.
> sp_spaceused
> For getting the size of table in order:-
> select object_name(id) as Table_name,rowcnt as record_count
> from sysindexes
> where indid IN (0, 1)
> order by rowcnt desc
> TO get the correct result execute DBCC UPDATEUSAGE (see books online) before
> the above select statement.
> Thanks
> Hari
> SQL Server MVP
>
> "ReTF" <re.tf@.newsgroup.nospam> wrote in message
> news:OABd$z7aFHA.3808@.TK2MSFTNGP14.phx.gbl...
>
>

How I can to treat a largest table, db?

Hi All,
I have one doubt about largest database, largest tables etc.
For example:
I have one db that have a table with 10.000.000.000 (or more) of register,
and I need get each register and do same thing with it (think that db is
about a credit card and the registers are the transactions of customers, and
I need print the invoices)
If I try use SELECT * FROM. the dm return 10.000.000.000, this is not good.
How I get one by one of table.
How I can to treat (to manipulate) a largest table, db? What are the ways?
What are the tricks?
Can you show me?
ThanksHi,
Execute the system stored procedure with out parameters to get the size of
all databases
sp_databases
To get the actual usage of data and indexes then execute the below comand in
the context of a database.
sp_spaceused
For getting the size of table in order:-
select object_name(id) as Table_name,rowcnt as record_count
from sysindexes
where indid IN (0, 1)
order by rowcnt desc
TO get the correct result execute DBCC UPDATEUSAGE (see books online) before
the above select statement.
Thanks
Hari
SQL Server MVP
"ReTF" <re.tf@.newsgroup.nospam> wrote in message
news:OABd$z7aFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi All,
>
> I have one doubt about largest database, largest tables etc.
>
> For example:
>
> I have one db that have a table with 10.000.000.000 (or more) of register,
> and I need get each register and do same thing with it (think that db is
> about a credit card and the registers are the transactions of customers,
> and I need print the invoices)
>
> If I try use SELECT * FROM. the dm return 10.000.000.000, this is not
> good.
> How I get one by one of table.
>
> How I can to treat (to manipulate) a largest table, db? What are the ways?
> What are the tricks?
>
> Can you show me?
>
> Thanks
>|||that table should have a key, and you should use the key for the record you
want
along with 'WHERE'
it works something like,
SELECT *
FROM bigtable
WHERE thekey = '123'
this will select only one record.
"Hari Prasad" wrote:

> Hi,
> Execute the system stored procedure with out parameters to get the size of
> all databases
> sp_databases
> To get the actual usage of data and indexes then execute the below comand
in
> the context of a database.
> sp_spaceused
> For getting the size of table in order:-
> select object_name(id) as Table_name,rowcnt as record_count
> from sysindexes
> where indid IN (0, 1)
> order by rowcnt desc
> TO get the correct result execute DBCC UPDATEUSAGE (see books online) befo
re
> the above select statement.
> Thanks
> Hari
> SQL Server MVP
>
> "ReTF" <re.tf@.newsgroup.nospam> wrote in message
> news:OABd$z7aFHA.3808@.TK2MSFTNGP14.phx.gbl...
>
>

How I can to treat a largest table, db?

Hi All,
I have one doubt about largest database, largest tables etc.
For example:
I have one db that have a table with 10.000.000.000 (or more) of register,
and I need get each register and do same thing with it (think that db is
about a credit card and the registers are the transactions of customers, and
I need print the invoices)
If I try use SELECT * FROM. the dm return 10.000.000.000, this is not good.
How I get one by one of table.
How I can to treat (to manipulate) a largest table, db? What are the ways?
What are the tricks?
Can you show me?
ThanksHi,
Execute the system stored procedure with out parameters to get the size of
all databases
sp_databases
To get the actual usage of data and indexes then execute the below comand in
the context of a database.
sp_spaceused
For getting the size of table in order:-
select object_name(id) as Table_name,rowcnt as record_count
from sysindexes
where indid IN (0, 1)
order by rowcnt desc
TO get the correct result execute DBCC UPDATEUSAGE (see books online) before
the above select statement.
Thanks
Hari
SQL Server MVP
"ReTF" <re.tf@.newsgroup.nospam> wrote in message
news:OABd$z7aFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi All,
>
> I have one doubt about largest database, largest tables etc.
>
> For example:
>
> I have one db that have a table with 10.000.000.000 (or more) of register,
> and I need get each register and do same thing with it (think that db is
> about a credit card and the registers are the transactions of customers,
> and I need print the invoices)
>
> If I try use SELECT * FROM. the dm return 10.000.000.000, this is not
> good.
> How I get one by one of table.
>
> How I can to treat (to manipulate) a largest table, db? What are the ways?
> What are the tricks?
>
> Can you show me?
>
> Thanks
>|||that table should have a key, and you should use the key for the record you
want
along with 'WHERE'
it works something like,
SELECT *
FROM bigtable
WHERE thekey = '123'
this will select only one record.
"Hari Prasad" wrote:
> Hi,
> Execute the system stored procedure with out parameters to get the size of
> all databases
> sp_databases
> To get the actual usage of data and indexes then execute the below comand in
> the context of a database.
> sp_spaceused
> For getting the size of table in order:-
> select object_name(id) as Table_name,rowcnt as record_count
> from sysindexes
> where indid IN (0, 1)
> order by rowcnt desc
> TO get the correct result execute DBCC UPDATEUSAGE (see books online) before
> the above select statement.
> Thanks
> Hari
> SQL Server MVP
>
> "ReTF" <re.tf@.newsgroup.nospam> wrote in message
> news:OABd$z7aFHA.3808@.TK2MSFTNGP14.phx.gbl...
> > Hi All,
> >
> >
> >
> > I have one doubt about largest database, largest tables etc.
> >
> >
> >
> > For example:
> >
> >
> >
> > I have one db that have a table with 10.000.000.000 (or more) of register,
> > and I need get each register and do same thing with it (think that db is
> > about a credit card and the registers are the transactions of customers,
> > and I need print the invoices)
> >
> >
> >
> > If I try use SELECT * FROM. the dm return 10.000.000.000, this is not
> > good.
> >
> > How I get one by one of table.
> >
> >
> >
> > How I can to treat (to manipulate) a largest table, db? What are the ways?
> > What are the tricks?
> >
> >
> >
> > Can you show me?
> >
> >
> >
> > Thanks
> >
> >
>
>