how to determine who has dba privileges?

for sql servers how can i determine who are the dbas?Hi,
Execute the below command:-
sp_helpsrvrolemember 'SYSADMIN'
Who ever comes under this result set will be able to do all the activities
inside that sql server instance.
For Database level DBA previlages, execute
sp_helprolemember 'db_owner'
Thanks
Hari
SQL Server MVP
"nlehrer" <nlehrer@.discussions.microsoft.com> wrote in message
news:CECA1001-EC8C-4EEC-866F-ECEB6B3C5C44@.microsoft.com...
> for sql servers how can i determine who are the dbas?|||thanks. where do i enter the command?
"Hari Prasad" wrote:

> Hi,
> Execute the below command:-
> sp_helpsrvrolemember 'SYSADMIN'
> Who ever comes under this result set will be able to do all the activities
> inside that sql server instance.
> For Database level DBA previlages, execute
> sp_helprolemember 'db_owner'
> Thanks
> Hari
> SQL Server MVP
>
>
> "nlehrer" <nlehrer@.discussions.microsoft.com> wrote in message
> news:CECA1001-EC8C-4EEC-866F-ECEB6B3C5C44@.microsoft.com...
>
>|||Hi,
Login to SQL Server using Query analyzer and enter your commands.
If it is MSDE then execute the commands from command prompt
OSQL -E
This will allow you to go to a SQL prompt, there u could type those
commands.
Thanks
Hari
SQL Server Mvp
"nlehrer" <nlehrer@.discussions.microsoft.com> wrote in message
news:9B6BA8B8-CFA5-4435-B6C1-9906B7DBD8D4@.microsoft.com...[vbcol=seagreen]
> thanks. where do i enter the command?
> "Hari Prasad" wrote:
>|||thank you.
"Hari Prasad" wrote:

> Hi,
> Login to SQL Server using Query analyzer and enter your commands.
>
> If it is MSDE then execute the commands from command prompt
> OSQL -E
> This will allow you to go to a SQL prompt, there u could type those
> commands.
> Thanks
> Hari
> SQL Server Mvp
> "nlehrer" <nlehrer@.discussions.microsoft.com> wrote in message
> news:9B6BA8B8-CFA5-4435-B6C1-9906B7DBD8D4@.microsoft.com...
>
>

How to deploy large sets of data.

How can a large set of data be deployed and implemented by a local DBA.
Large set of data for example over 1 Gigabyte.
For example consisting of 1000 rows of data.
For example for text data ?
Or for binairy data ?
Large set of data, for example over 3 Gigabyte and consisting of
many rows ? (Milions of rows).
The implementation has to be as simple as possible for the local DBA,
thanks for your attention,
ben brugman
1 way would be :-
Copy the data out of SQL Server to a text file via (DTS, BCP)
The local DBA then runs a BULK INSERT script to import
HTH. Ryan
"ben brugman" <ben@.niethier.nl> wrote in message
news:%23Y4af8qGGHA.740@.TK2MSFTNGP12.phx.gbl...
> How can a large set of data be deployed and implemented by a local DBA.
> Large set of data for example over 1 Gigabyte.
> For example consisting of 1000 rows of data.
> For example for text data ?
> Or for binairy data ?
> Large set of data, for example over 3 Gigabyte and consisting of
> many rows ? (Milions of rows).
> The implementation has to be as simple as possible for the local DBA,
> thanks for your attention,
> ben brugman
>
|||"ben brugman" <ben@.niethier.nl> wrote in message
news:%23Y4af8qGGHA.740@.TK2MSFTNGP12.phx.gbl...
> How can a large set of data be deployed and implemented by a local DBA.
> Large set of data for example over 1 Gigabyte.
> For example consisting of 1000 rows of data.
> For example for text data ?
> Or for binairy data ?
> Large set of data, for example over 3 Gigabyte and consisting of
> many rows ? (Milions of rows).
> The implementation has to be as simple as possible for the local DBA,
> thanks for your attention,
> ben brugman
>
There are several approaces that you can take...
Use multiple files for your data and use sp_detach_db and sp_attach_db.
(Script any SQL authenticated logins if moving to a new machine in a new
environment)
Simply use Backup and Restore.
(Script any SQL authenticated logins if moving to a new machine in a new
environment)
If there are size issues. For example a 3GB backup file is too big to FTP,
or put on a CD etc. You could do a multi-file backup, Zip each file and
then move them. Unzip and restore.
Those are probably the easiest for a dba to perform.
Rick Sawtell
MCT, MCSD, MCDBA

How to deploy large sets of data.

How can a large set of data be deployed and implemented by a local DBA.
Large set of data for example over 1 Gigabyte.
For example consisting of 1000 rows of data.
For example for text data ?
Or for binairy data ?
Large set of data, for example over 3 Gigabyte and consisting of
many rows ? (Milions of rows).
The implementation has to be as simple as possible for the local DBA,
thanks for your attention,
ben brugman1 way would be :-
Copy the data out of SQL Server to a text file via (DTS, BCP)
The local DBA then runs a BULK INSERT script to import
HTH. Ryan
"ben brugman" <ben@.niethier.nl> wrote in message
news:%23Y4af8qGGHA.740@.TK2MSFTNGP12.phx.gbl...
> How can a large set of data be deployed and implemented by a local DBA.
> Large set of data for example over 1 Gigabyte.
> For example consisting of 1000 rows of data.
> For example for text data ?
> Or for binairy data ?
> Large set of data, for example over 3 Gigabyte and consisting of
> many rows ? (Milions of rows).
> The implementation has to be as simple as possible for the local DBA,
> thanks for your attention,
> ben brugman
>|||"ben brugman" <ben@.niethier.nl> wrote in message
news:%23Y4af8qGGHA.740@.TK2MSFTNGP12.phx.gbl...
> How can a large set of data be deployed and implemented by a local DBA.
> Large set of data for example over 1 Gigabyte.
> For example consisting of 1000 rows of data.
> For example for text data ?
> Or for binairy data ?
> Large set of data, for example over 3 Gigabyte and consisting of
> many rows ? (Milions of rows).
> The implementation has to be as simple as possible for the local DBA,
> thanks for your attention,
> ben brugman
>
There are several approaces that you can take...
Use multiple files for your data and use sp_detach_db and sp_attach_db.
(Script any SQL authenticated logins if moving to a new machine in a new
environment)
Simply use Backup and Restore.
(Script any SQL authenticated logins if moving to a new machine in a new
environment)
If there are size issues. For example a 3GB backup file is too big to FTP,
or put on a CD etc. You could do a multi-file backup, Zip each file and
then move them. Unzip and restore.
Those are probably the easiest for a dba to perform.
Rick Sawtell
MCT, MCSD, MCDBA

How to deploy large sets of data.

How can a large set of data be deployed and implemented by a local DBA.
Large set of data for example over 1 Gigabyte.
For example consisting of 1000 rows of data.
For example for text data ?
Or for binairy data ?
Large set of data, for example over 3 Gigabyte and consisting of
many rows ? (Milions of rows).
The implementation has to be as simple as possible for the local DBA,
thanks for your attention,
ben brugman1 way would be :-
Copy the data out of SQL Server to a text file via (DTS, BCP)
The local DBA then runs a BULK INSERT script to import
--
HTH. Ryan
"ben brugman" <ben@.niethier.nl> wrote in message
news:%23Y4af8qGGHA.740@.TK2MSFTNGP12.phx.gbl...
> How can a large set of data be deployed and implemented by a local DBA.
> Large set of data for example over 1 Gigabyte.
> For example consisting of 1000 rows of data.
> For example for text data ?
> Or for binairy data ?
> Large set of data, for example over 3 Gigabyte and consisting of
> many rows ? (Milions of rows).
> The implementation has to be as simple as possible for the local DBA,
> thanks for your attention,
> ben brugman
>|||"ben brugman" <ben@.niethier.nl> wrote in message
news:%23Y4af8qGGHA.740@.TK2MSFTNGP12.phx.gbl...
> How can a large set of data be deployed and implemented by a local DBA.
> Large set of data for example over 1 Gigabyte.
> For example consisting of 1000 rows of data.
> For example for text data ?
> Or for binairy data ?
> Large set of data, for example over 3 Gigabyte and consisting of
> many rows ? (Milions of rows).
> The implementation has to be as simple as possible for the local DBA,
> thanks for your attention,
> ben brugman
>
There are several approaces that you can take...
Use multiple files for your data and use sp_detach_db and sp_attach_db.
(Script any SQL authenticated logins if moving to a new machine in a new
environment)
Simply use Backup and Restore.
(Script any SQL authenticated logins if moving to a new machine in a new
environment)
If there are size issues. For example a 3GB backup file is too big to FTP,
or put on a CD etc. You could do a multi-file backup, Zip each file and
then move them. Unzip and restore.
Those are probably the easiest for a dba to perform.
Rick Sawtell
MCT, MCSD, MCDBA

How to defrag an SQL 7 AND 2000 server?

Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We
have both ver. 7 and 2000 (running on two different systems). I am not a
DBA but I really need to get this done tonight (2/24/2006) while we take our
systems down. I will also want to defrag the Windows 2000 and Windows 2003
NTSF file system volumes. Thanks for any and all input.
I will need the commands and where to run the commands (i.e. command prompt,
inside Enterprise Manager or inside Query Analyzer). I don't know anything
about SQL so go easy on me.
ClaytonHere is a quick but effective way to reindex all the tables in a specific db
which will defrag the tables and indexes. If you want to defrag the OS
files you would simply use one of the tools designed for that such as
DiskKeeper, Norton etc. You should make sure you have a good backup before
you start and turn off sql server before you do the OS defrag for best
results.
--
Andrew J. Kelly SQL MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OAnWhaVOGHA.3576@.TK2MSFTNGP15.phx.gbl...
> Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We
> have both ver. 7 and 2000 (running on two different systems). I am not a
> DBA but I really need to get this done tonight (2/24/2006) while we take
> our systems down. I will also want to defrag the Windows 2000 and Windows
> 2003 NTSF file system volumes. Thanks for any and all input.
> I will need the commands and where to run the commands (i.e. command
> prompt, inside Enterprise Manager or inside Query Analyzer). I don't know
> anything about SQL so go easy on me.
>
> Clayton
>|||Hey Andrew,
Thanks for the reply. See inline comments.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uAxOe2WOGHA.1312@.TK2MSFTNGP09.phx.gbl...
> Here is a quick but effective way to reindex all the tables in a specific
> db which will defrag the tables and indexes.
What? How? Did you forget to give me the info?
> If you want to defrag the OS files you would simply use one of the tools
> designed for that such as DiskKeeper, Norton etc.
I will just be using Windows built-in defrag utility
> You should make sure you have a good backup before you start and turn off
> sql server before you do the OS defrag for best results.
I will stop all SQL services first.
But what are the commands to defrag ALL of the DBs on the server? Are you
saying that if a defrag the NTFS volume that that will defrag ALL the DBs
too? Are there not SQL commands that I need to run to defrag ALL of the
DBs?
Clayton
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OAnWhaVOGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We
>> have both ver. 7 and 2000 (running on two different systems). I am not a
>> DBA but I really need to get this done tonight (2/24/2006) while we take
>> our systems down. I will also want to defrag the Windows 2000 and
>> Windows 2003 NTSF file system volumes. Thanks for any and all input.
>> I will need the commands and where to run the commands (i.e. command
>> prompt, inside Enterprise Manager or inside Query Analyzer). I don't
>> know anything about SQL so go easy on me.
>>
>> Clayton
>|||Sorry I forgot to do the paste, see below for the code:
> But what are the commands to defrag ALL of the DBs on the server? Are you
> saying that if a defrag the NTFS volume that that will defrag ALL the DBs
> too? Are there not SQL commands that I need to run to defrag ALL of the
> DBs?
Defragging at the OS level does nothing towards defragging the tables and
indexes. You would have to run the above script on each database.
--
SET NOCOUNT ON
DECLARE @.TableName VARCHAR(100)
DECLARE curTables CURSOR STATIC LOCAL
FOR
SELECT Table_Name
FROM Information_Schema.Tables
WHERE Table_Type = 'BASE TABLE'
OPEN curTables
FETCH NEXT FROM curTables INTO @.TableName
SET @.TableName = RTRIM(@.TableName)
WHILE @.@.FETCH_STATUS = 0
BEGIN
SELECT 'Reindexing ' + @.TableName
DBCC DBREINDEX (@.TableName)
FETCH NEXT FROM curTables INTO @.TableName
END
CLOSE curTables
DEALLOCATE curTables
Andrew J. Kelly SQL MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:u9FgfOYOGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hey Andrew,
> Thanks for the reply. See inline comments.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uAxOe2WOGHA.1312@.TK2MSFTNGP09.phx.gbl...
>> Here is a quick but effective way to reindex all the tables in a specific
>> db which will defrag the tables and indexes.
> What? How? Did you forget to give me the info?
>> If you want to defrag the OS files you would simply use one of the tools
>> designed for that such as DiskKeeper, Norton etc.
> I will just be using Windows built-in defrag utility
>> You should make sure you have a good backup before you start and turn off
>> sql server before you do the OS defrag for best results.
> I will stop all SQL services first.
> But what are the commands to defrag ALL of the DBs on the server? Are you
> saying that if a defrag the NTFS volume that that will defrag ALL the DBs
> too? Are there not SQL commands that I need to run to defrag ALL of the
> DBs?
>
> Clayton
>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:OAnWhaVOGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We
>> have both ver. 7 and 2000 (running on two different systems). I am not
>> a DBA but I really need to get this done tonight (2/24/2006) while we
>> take our systems down. I will also want to defrag the Windows 2000 and
>> Windows 2003 NTSF file system volumes. Thanks for any and all input.
>> I will need the commands and where to run the commands (i.e. command
>> prompt, inside Enterprise Manager or inside Query Analyzer). I don't
>> know anything about SQL so go easy on me.
>>
>> Clayton
>>
>|||Hey Andrew,
Getting ready to go into work to get started (9:30pm CST). Just one more
question. How do I run the script? In a DOS Command Prompt? In a "Text"
file and call it "SomeFile.vbs"? Do I copy ad paste it into an MSSQL GUI
interface somewhere? Thanks for your help.
Clayton
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OBxAvZZOGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Sorry I forgot to do the paste, see below for the code:
>> But what are the commands to defrag ALL of the DBs on the server? Are
>> you saying that if a defrag the NTFS volume that that will defrag ALL the
>> DBs too? Are there not SQL commands that I need to run to defrag ALL of
>> the DBs?
> Defragging at the OS level does nothing towards defragging the tables and
> indexes. You would have to run the above script on each database.
> --
> SET NOCOUNT ON
> DECLARE @.TableName VARCHAR(100)
>
> DECLARE curTables CURSOR STATIC LOCAL
> FOR
> SELECT Table_Name
> FROM Information_Schema.Tables
> WHERE Table_Type = 'BASE TABLE'
> OPEN curTables
> FETCH NEXT FROM curTables INTO @.TableName
> SET @.TableName = RTRIM(@.TableName)
> WHILE @.@.FETCH_STATUS = 0
> BEGIN
> SELECT 'Reindexing ' + @.TableName
> DBCC DBREINDEX (@.TableName)
> FETCH NEXT FROM curTables INTO @.TableName
> END
> CLOSE curTables
> DEALLOCATE curTables
>
> --
> Andrew J. Kelly SQL MVP
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:u9FgfOYOGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hey Andrew,
>> Thanks for the reply. See inline comments.
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:uAxOe2WOGHA.1312@.TK2MSFTNGP09.phx.gbl...
>> Here is a quick but effective way to reindex all the tables in a
>> specific db which will defrag the tables and indexes.
>> What? How? Did you forget to give me the info?
>> If you want to defrag the OS files you would simply use one of the tools
>> designed for that such as DiskKeeper, Norton etc.
>> I will just be using Windows built-in defrag utility
>> You should make sure you have a good backup before you start and turn
>> off sql server before you do the OS defrag for best results.
>> I will stop all SQL services first.
>> But what are the commands to defrag ALL of the DBs on the server? Are
>> you saying that if a defrag the NTFS volume that that will defrag ALL the
>> DBs too? Are there not SQL commands that I need to run to defrag ALL of
>> the DBs?
>>
>> Clayton
>>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:OAnWhaVOGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server.
>> We have both ver. 7 and 2000 (running on two different systems). I am
>> not a DBA but I really need to get this done tonight (2/24/2006) while
>> we take our systems down. I will also want to defrag the Windows 2000
>> and Windows 2003 NTSF file system volumes. Thanks for any and all
>> input.
>> I will need the commands and where to run the commands (i.e. command
>> prompt, inside Enterprise Manager or inside Query Analyzer). I don't
>> know anything about SQL so go easy on me.
>>
>> Clayton
>>
>>
>|||The easiest way is to use Query Analyzer and paste the code into the window
and hit the F5 key. Query Analyzer should be found under SQL Servers folder
of the programs menu.
Andrew J. Kelly SQL MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:evR7iwbOGHA.2888@.tk2msftngp13.phx.gbl...
> Hey Andrew,
> Getting ready to go into work to get started (9:30pm CST). Just one more
> question. How do I run the script? In a DOS Command Prompt? In a "Text"
> file and call it "SomeFile.vbs"? Do I copy ad paste it into an MSSQL GUI
> interface somewhere? Thanks for your help.
>
> Clayton
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OBxAvZZOGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Sorry I forgot to do the paste, see below for the code:
>> But what are the commands to defrag ALL of the DBs on the server? Are
>> you saying that if a defrag the NTFS volume that that will defrag ALL
>> the DBs too? Are there not SQL commands that I need to run to defrag
>> ALL of the DBs?
>> Defragging at the OS level does nothing towards defragging the tables and
>> indexes. You would have to run the above script on each database.
>> --
>> SET NOCOUNT ON
>> DECLARE @.TableName VARCHAR(100)
>>
>> DECLARE curTables CURSOR STATIC LOCAL
>> FOR
>> SELECT Table_Name
>> FROM Information_Schema.Tables
>> WHERE Table_Type = 'BASE TABLE'
>> OPEN curTables
>> FETCH NEXT FROM curTables INTO @.TableName
>> SET @.TableName = RTRIM(@.TableName)
>> WHILE @.@.FETCH_STATUS = 0
>> BEGIN
>> SELECT 'Reindexing ' + @.TableName
>> DBCC DBREINDEX (@.TableName)
>> FETCH NEXT FROM curTables INTO @.TableName
>> END
>> CLOSE curTables
>> DEALLOCATE curTables
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:u9FgfOYOGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hey Andrew,
>> Thanks for the reply. See inline comments.
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:uAxOe2WOGHA.1312@.TK2MSFTNGP09.phx.gbl...
>> Here is a quick but effective way to reindex all the tables in a
>> specific db which will defrag the tables and indexes.
>> What? How? Did you forget to give me the info?
>> If you want to defrag the OS files you would simply use one of the
>> tools designed for that such as DiskKeeper, Norton etc.
>> I will just be using Windows built-in defrag utility
>> You should make sure you have a good backup before you start and turn
>> off sql server before you do the OS defrag for best results.
>> I will stop all SQL services first.
>> But what are the commands to defrag ALL of the DBs on the server? Are
>> you saying that if a defrag the NTFS volume that that will defrag ALL
>> the DBs too? Are there not SQL commands that I need to run to defrag
>> ALL of the DBs?
>>
>> Clayton
>>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:OAnWhaVOGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server.
>> We have both ver. 7 and 2000 (running on two different systems). I am
>> not a DBA but I really need to get this done tonight (2/24/2006) while
>> we take our systems down. I will also want to defrag the Windows 2000
>> and Windows 2003 NTSF file system volumes. Thanks for any and all
>> input.
>> I will need the commands and where to run the commands (i.e. command
>> prompt, inside Enterprise Manager or inside Query Analyzer). I don't
>> know anything about SQL so go easy on me.
>>
>> Clayton
>>
>>
>>
>|||Cool, thank you VERY much Andrew!
Clayton
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uGXTyDhOGHA.3284@.TK2MSFTNGP14.phx.gbl...
> The easiest way is to use Query Analyzer and paste the code into the
> window and hit the F5 key. Query Analyzer should be found under SQL
> Servers folder of the programs menu.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:evR7iwbOGHA.2888@.tk2msftngp13.phx.gbl...
>> Hey Andrew,
>> Getting ready to go into work to get started (9:30pm CST). Just one more
>> question. How do I run the script? In a DOS Command Prompt? In a
>> "Text" file and call it "SomeFile.vbs"? Do I copy ad paste it into an
>> MSSQL GUI interface somewhere? Thanks for your help.
>>
>> Clayton
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:OBxAvZZOGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Sorry I forgot to do the paste, see below for the code:
>> But what are the commands to defrag ALL of the DBs on the server? Are
>> you saying that if a defrag the NTFS volume that that will defrag ALL
>> the DBs too? Are there not SQL commands that I need to run to defrag
>> ALL of the DBs?
>> Defragging at the OS level does nothing towards defragging the tables
>> and indexes. You would have to run the above script on each database.
>> --
>> SET NOCOUNT ON
>> DECLARE @.TableName VARCHAR(100)
>>
>> DECLARE curTables CURSOR STATIC LOCAL
>> FOR
>> SELECT Table_Name
>> FROM Information_Schema.Tables
>> WHERE Table_Type = 'BASE TABLE'
>> OPEN curTables
>> FETCH NEXT FROM curTables INTO @.TableName
>> SET @.TableName = RTRIM(@.TableName)
>> WHILE @.@.FETCH_STATUS = 0
>> BEGIN
>> SELECT 'Reindexing ' + @.TableName
>> DBCC DBREINDEX (@.TableName)
>> FETCH NEXT FROM curTables INTO @.TableName
>> END
>> CLOSE curTables
>> DEALLOCATE curTables
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:u9FgfOYOGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hey Andrew,
>> Thanks for the reply. See inline comments.
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
>> news:uAxOe2WOGHA.1312@.TK2MSFTNGP09.phx.gbl...
>> Here is a quick but effective way to reindex all the tables in a
>> specific db which will defrag the tables and indexes.
>> What? How? Did you forget to give me the info?
>> If you want to defrag the OS files you would simply use one of the
>> tools designed for that such as DiskKeeper, Norton etc.
>> I will just be using Windows built-in defrag utility
>> You should make sure you have a good backup before you start and turn
>> off sql server before you do the OS defrag for best results.
>> I will stop all SQL services first.
>> But what are the commands to defrag ALL of the DBs on the server? Are
>> you saying that if a defrag the NTFS volume that that will defrag ALL
>> the DBs too? Are there not SQL commands that I need to run to defrag
>> ALL of the DBs?
>>
>> Clayton
>>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:OAnWhaVOGHA.3576@.TK2MSFTNGP15.phx.gbl...
>> Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server.
>> We have both ver. 7 and 2000 (running on two different systems). I
>> am not a DBA but I really need to get this done tonight (2/24/2006)
>> while we take our systems down. I will also want to defrag the
>> Windows 2000 and Windows 2003 NTSF file system volumes. Thanks for
>> any and all input.
>> I will need the commands and where to run the commands (i.e. command
>> prompt, inside Enterprise Manager or inside Query Analyzer). I don't
>> know anything about SQL so go easy on me.
>>
>> Clayton
>>
>>
>>
>>
>