Thanks Gail.

Tempdb original size was 10 GB and was running without any issue with this size till last week.

We are having 100 databases on this box, and One of...

75 GB is purely data file and size of log is 3.5 gb

Thanks John...

We I have already tried dbcc shrinkdatabase and shrinkfile and both are giving same error. This being our production server we are looking alternatives without restarting SQL service.

I am using Access 2000 i.e. supplied with Office 2000.

HI Markus,

I agree that for 2000 we need to do it by profiler or third party tool.

For 2005, for events like security changes/schema changes I have tested using Notification. But...

Instead of using profiler trace, using event notification we can store records for required events in a table. Laster, using SSRS a report can be developed which displays changes done...

Hi,

I have checked as per your suggestion ...

1. There is fragmentation, I will defragment the volume and post the result.

2. Perform volume maintenance task permission is given to Administrators &...

Hi,

Can U try replacing following line in code

exec @rc = sp_trace_create @TraceID output, 0, N'd:\jobs\duration', @maxfilesize, NULL

with

exec @rc = sp_trace_create @TraceID output, 2, N'd:\jobs\duration', @maxfilesize, NULL

and...

1) Checked this query " SELECT * FROM SYS.SYSALTFILES WHERE DBID=DB_ID('Db_name') " It is showing 1 GB Growth, maxsize unlimited

2) After running XP_FIXEDDRIVES it is showing Free Space on Drive...

Hi Ratheesh/Murthykalyani,

I am using SQL Server 2005, Enterprise Edition and Service pack is 2.

The drive on which database resides is having ample space. But when the system tries to auto...

Sorry, I could not reply immediately...

1. All files are in primary filegroup

2. When I am trying to increase file size for any primary data file, it is giving following error

Alter...

Hi,

I have 500 GB free space on the drive, on which primary filegroup resides. Size of the files are as given below

1st Data File 69223 MB

2nd Data File 43600 MB...

As U R not in domain, I think U R using SQL Logins. So first create SQL logins using Management Studio or Create login.....

Then using either Create user or thru...

Add the user in master database and grant execute on xp_cmdshell and try.

If still U R not able to use xp_cmdshell then add windows account (If U R not in...

Hi Sakthivel,

We are able to login using SQL authentication from his machine as well as from my machine. On restart also, there is no change in this.

In fact when I...