Remote Stored Proc Call

I'm calling this from another sql server...
I created a linked server... and want to restore database backups on the other box...
The restore script runs fine when ran locally but fails with the message below when calling it remotely

Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.

CREATE PROCEDURE usp_restore_database_backups AS

RESTORE DATABASE BesMgmt
FROM DISK = 'D:\MSSQL\BACKUP\BesMgmt\BesMgmt_backup_device.bak '
WITH
--DBO_ONLY,
REPLACE,
--STANDBY = 'D:\MSSQL\Data\BesMgmt\undo_BesMgmt.ldf',
MOVE 'BesMgmt_data' TO 'D:\MSSQL\Data\BesMgmt.mdf',
MOVE 'BesMgmt_log' TO 'D:\MSSQL\Data\BesMgmt.ldf'

WAITFOR DELAY '00:00:05'

EXEC sp_dboption 'BesMgmt', 'single user', true
GO

I have set it to read only dbo only ... single user... still get the same message...
does anyone have any suggestions...try executing...

ALTER DATABASE <MyDB> SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

or

ALTER DATABASE <MyDB> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

before the restore statement and drop the sp_dboption.|||thanks Thrasymachus
I'm still getting the same error:
Executed as user: NFCU\sqlsvc. RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013) Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] (Error 3101). The step failed.|||post the script you are currently using and try running sp_who when it fails to see what connections are in use. Also when you execute this script in the QA are you connected to the database you are trying to restore? The database selected from the dropdown should not be the database you are trying to restore. If everything is OK with your script I suspect this is the case.|||The error does not tally with this but just belt and braces.

If you run
EXEC sp_helpserver

do you see RPC & RPC out in the status field?|||When I set the database manually into single user mode I get a different error when trying to restore the database... this is the error that comes from when the database is in single user mode....
"Executed as user: NFCU\sqlsvc. Cannot open database requested in login 'BESMgmt'. Login fails. [SQLSTATE 42000] (Error 4060). The step failed."

CREATE PROCEDURE usp_restore_database_backups AS

/*
declare @.x varchar(255)
select @.x = @.x + ' kill ' + convert(varchar(5), spid)
from master.dbo.sysprocesses
where dbid = db_id ('BesMgmt')
exec (@.x)
*/

ALTER DATABASE BesMgmt SET SINGLE_USER WITH ROLLBACK IMMEDIATE

RESTORE DATABASE BesMgmt
FROM DISK = 'D:\MSSQL\BACKUP\BesMgmt\BesMgmt_backup_device.bak '
WITH
--DBO_ONLY,
REPLACE,
--STANDBY = 'D:\MSSQL\Data\BesMgmt\undo_BesMgmt.ldf',
MOVE 'BesMgmt_data' TO 'D:\MSSQL\Data\BesMgmt.mdf',
MOVE 'BesMgmt_log' TO 'D:\MSSQL\Data\BesMgmt.ldf'

WAITFOR DELAY '00:00:05'

--EXEC sp_dboption 'BesMgmt', 'single user', true
GO|||The command is within a job...
the sql agent service is ran under a domain user acount...

Remote server backups to local drive?

Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Remote server backups to local drive?

Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Remote server backups to local drive?

Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.
ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>
|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Remote restore question

Hello everyone,
Quick question. We perform db backups at 10pm on a certain database
that is about 12 gig. Then the transaction log is backed up every
hour. We'd like to restore this database to another off site server,
then apply the logs to keep it in sync w/ production. I've tested this
and it seems to work fine. My only question is regarding the full
backups that are performed every night. Due to bandwidth limitations,
we can't get the full db backup to the remote server in a reasonable
amount of time (the logs can make it over within one hour no problem).
Can we just keep restoring the logs on the remote server without the
nightly db backups being restored? I guess I'm asking if the full db
backup does anything to the log (empties it or the like) that would
make the dbs out of sync?
Thanks in advance.That would be fine. This is one of the reasons why a full backup doesn't
truncate the transaction log. But I suggest you have operational
instructions readily available on how to do this manually, in case the log
restores becomes out of sync, for any reason...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"sqlboy2000" <sqlboy2000@.hotmail.com> wrote in message
news:49e85cd3.0403171311.6b65aab4@.posting.google.com...
> Hello everyone,
> Quick question. We perform db backups at 10pm on a certain database
> that is about 12 gig. Then the transaction log is backed up every
> hour. We'd like to restore this database to another off site server,
> then apply the logs to keep it in sync w/ production. I've tested this
> and it seems to work fine. My only question is regarding the full
> backups that are performed every night. Due to bandwidth limitations,
> we can't get the full db backup to the remote server in a reasonable
> amount of time (the logs can make it over within one hour no problem).
> Can we just keep restoring the logs on the remote server without the
> nightly db backups being restored? I guess I'm asking if the full db
> backup does anything to the log (empties it or the like) that would
> make the dbs out of sync?
> Thanks in advance.|||You can restore logs in sequence on a SQL 7.0 or 2000 and ignore intervening
full backups. This is intentional so that if a full backup goes bad, you
can go to an older full backup and restore more logs to get your database up
to the last committed transaction.
BTW, this is called log-shipping. SQL enterprise edition includes it as
built-in, but many people write their own routines to handle situations and
configurations not directly supported but the built-in tools.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"sqlboy2000" <sqlboy2000@.hotmail.com> wrote in message
news:49e85cd3.0403171311.6b65aab4@.posting.google.com...
> Hello everyone,
> Quick question. We perform db backups at 10pm on a certain database
> that is about 12 gig. Then the transaction log is backed up every
> hour. We'd like to restore this database to another off site server,
> then apply the logs to keep it in sync w/ production. I've tested this
> and it seems to work fine. My only question is regarding the full
> backups that are performed every night. Due to bandwidth limitations,
> we can't get the full db backup to the remote server in a reasonable
> amount of time (the logs can make it over within one hour no problem).
> Can we just keep restoring the logs on the remote server without the
> nightly db backups being restored? I guess I'm asking if the full db
> backup does anything to the log (empties it or the like) that would
> make the dbs out of sync?
> Thanks in advance.|||Excellent. Thanks to both of you.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:<enVq$YGDEHA.1588@.tk2msftn
gp13.phx.gbl>...
> You can restore logs in sequence on a SQL 7.0 or 2000 and ignore interveni
ng
> full backups. This is intentional so that if a full backup goes bad, you
> can go to an older full backup and restore more logs to get your database
up
> to the last committed transaction.
> BTW, this is called log-shipping. SQL enterprise edition includes it as
> built-in, but many people write their own routines to handle situations an
d
> configurations not directly supported but the built-in tools.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "sqlboy2000" <sqlboy2000@.hotmail.com> wrote in message
> news:49e85cd3.0403171311.6b65aab4@.posting.google.com...