Viewing 15 posts - 931 through 945 (of 1,065 total)
Is it x64 machine?
x86 update does not run on x64 machine.
September 22, 2008 at 6:29 am
use master
go
select * from sysprocesses
where blocked > 0
Above query shows if there is any blocking issue.
September 9, 2008 at 6:46 am
Under what circumstances they are preferable ?
It can help to improve the select query performance and avoid deadlocks.
August 28, 2008 at 5:03 am
Can anyone explain simply the difference between LDF data and TRN data
LDF file contains transaction log. Every database must have atleat one .LDF file.
TRN file contains transaction log backup....
August 28, 2008 at 1:06 am
In SQL Server 2008, it is possible to pass table as parameter.
In SQL Server 2005, you can use the work around mentioned in link:
August 27, 2008 at 7:16 am
Create an extra step between the steps to send e-mail notification.
On Failure: Go to the new next step which you just added
On Success: Go to the step next to the...
August 27, 2008 at 6:52 am
BOL:
All mirroring connections on a server instance use a single database mirroring endpoint.
August 25, 2008 at 7:41 am
management plan i enabled the earlier disabled plan
Enabled the schedule as well.
August 8, 2008 at 7:57 am
Convert(varchar
1) In the master database the column type may be correct (varbinary).
2) You are converting to varchar. You should convert to varbinary.
BTW master database should not be used to store...
August 7, 2008 at 6:55 am
is there a way to see the datatype and name for every column in the query?
Yes, it is listed in the BOL.
August 5, 2008 at 12:00 am
Is there a way to only script or disable the defaults so that I can alter the columns and can have defaults restored afterwards.
sp_unbinddefault
alter table
sp_binddefault
August 4, 2008 at 10:56 pm
but i dont know how to call that job and send a mail
Don't call the job. Schedule it to run at required interval.
See the BOL to know more about sp_send_dbmail....
August 4, 2008 at 6:53 am
Viewing 15 posts - 931 through 945 (of 1,065 total)