Hai,

Did you try DBCC CHECKTABLE(Transactions), DBCC CHECKALLOC

What is the error that you get.

Count(*) will be got from sysindexes table itself. So don't confuse with that.

Hai,

If you create a DTS package with a destination file then it always exports to that file only. Why don't you try with BCP. Have a variable to construct the...

The default set of NT credentials used by MSSQLSERVER is the Localsystem account. You can check what userid that MSSQLSERVER is running under by looking at control...

The AFTER UPDATE trigger intercepts triggering action and does something based on the logic that is in it. Probably that may not satisfy the condition written inside the trigger. Check...

Hai,

The entire delete is considered as a single transaction. So the log might be busy. Did you check the transaction log activity. The log cannot get itself stabilized inbetween. Please check that

A select statment always gets a shared lock on the resource by default. In case you do not want to have this lock issued(if it affects other users from having...

Hi,

Yes very much and the speed depends on your server configuration and the maintenance that you do. We have a database which contains more than one million rows(growing).

Hai,

If  you use an identity column as your unique clustered index you can greatly reduce the amount of fragementation because all of your inserts will occur at the end of the table. ...

Try this

select EmployeeId from EmployeeProject group by EmployeeId having count(*) >= (select count(distinct ProjectId) from Project)

Is it what you want

cheers

Hai,

Please try the follwoing statement

Select a.EffectiveDate As StartDate,

(select top 1 replace(convert(varchar(10),dateadd(dd,-1,EffectiveDate),126),'-','')

   from xdate x WHERE x.EffectiveDate > a.EffectiveDate order by EffectiveDate) as EndDate,Code1, Code2

from xdate a

You...

use msdb

go

select * from sysjobs

select * from sysjobsteps

select * from sysjobserver

select * from sysjobhistory

declare @value varchar(100)

select @value =coalesce(@value +',','')+value from t where id =1

select @value