FYI server reboot solved the problem.

Thanks all for your help!

Run this query in the desired database will give you your required information"

sp_msforeachtable 'sp_spaceused ''?'''

hope this will help.

Thanks.

no but you can ask developer to exclusively grant execute permission to specified user whenever they create any new stored procedure via GRANT statement at the end.

if there are many...

Are they on same file group? If yes then just empty the file and then you can delete that.

to empty file goto EM--all tasks--shrink database--files--select datafile--select the option to empty...

Hi,

visit this to move system databases:

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

Hope this will help you.

Thanks.

As Martin said, DBCC DBREINDEX is not online operation as that exclusively locks your table.

On the other hand, DBCC INDEXDEFRAG is online operation but it has it's own limitations.

now answer to...

Answer to your first question : I am not sure how much resource intensive dbcc showcontig() is but yes if you are using this for rebuilding your indexes then the...

Hi eric,

if you can explain me exactly what information you want from the database, i can help you out with sql but can't with VB

Thanks,

1. You can select the option "Disallow adhoc queries" option provided by ODBC provider

and for

2. logging audit : go to

http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx

check out the registration properties:login

that login might not have access privilages on the server you are trying to connect.

if you have set up your database option as to grow log file automatically without specifying the maximum size, it can take all your space depending on your system.

Along with...

This is very generaic error. I got this once when I was running my batch file for deleting data. You might want to try to breakdown your transaction.one possible reason...

I do not know the nitty gritty details about how to configure SQL Server to access remotely but yes if you want, either using remote desktop connection or by VPN.

If you can describe what action does the job perform?

Try this:

--The procedure below will give you information about the type of access which the  users has been granted. 

select user_name(b.uid)as username ,object_name(id) as objectname , case when action = 26 ...