What import activity you are referring here, is it within your application or import within SQL server? Generally this error can occur under the following circumstances:

• You are trying...

Practically instead of 30% fragmetation limit, Index should be rebuild when index fragmentation is great than 35-40%. Index should be reorganized when index fragmentation is between 10% to 35-40%. Index...

posting again the sytax, somehow parameters went missing in previous post.

xp_sqlagent_proxy_account N'SET'

...

When a login that's in the sysadmin role executes xp_cmdshell, it runs under the windows account that SQL Server is running under. When you grant the right to run xp_cmdshell...

whatever you are doing is correct, this is manual way of restoring the database with new name. Also you can write a stored procedure with two input parameters as DBName...

welcome 🙂

Try this out

select Left(filename, len(filename)-charindex('\',reverse(filename))+1) from [sysfiles]

HTH

You can list the issues which you want to fix or check on the latest SP or CU for the bugs/problems fixed in those. Without knowing the problem it is...

Jason, by any chance do you have replication set up on your server. If yes, please check if that is not broken. I had the similar situation where replication was...

sp_spaceused computes the amount of disk space used for data and indexes, and the disk space used by a table in the current database. If objname is not given, sp_spaceused...

you can use the object name with sp_spaceused to know about the size of object you are interested in. The exact syntax for it is:

sp_spaceused [[@objname =] 'objname']

...

you can use this sp_spaceused in query analyzer to know about the size of database. It will give you three columns: databasename, size and unallocated space

We also face the same problem when we changed the compatibility level from 80 to 90. Our application was a ASP web aplication and custom controls which were used in...

1. You should change security settings on IIS server. Right click on your website, go to properties and then Directory security. Edit and define windows user in Anonymous access, check...

I have come across one link

http://www.brothersoft.com/downloads/sql-server-2000.html

Never tried, you can give a try and check it this works