Hi ,

If u want to use the query for diffrent database use have to give the database name in brackets.

If u want to run the query for remote server then...

Hi,

By default sql server creats a database tempdb and stores information is sysdatabases in mater database.

Pls check is there anyentry left with the samename.

id there is then pls delete it.

The...

Hi shashank,

The information about Locks, Blocking Bottleneck are are stored in few system table sysprocesses,syslocks and syslockinfo in master database

if u query syslockinfo u will see a field rsc_objid this...

hi,

We got DBartisan that is really good and helping me from last 2 years in DBA ativities in shore and off shore.

from

Killer

Hi,

Put a trace on using Sql Profier and check but is going at the back.Check what are the longest runnig queries.

If the job is using longer time then before then...

Hi ,

Check the jobs , might be possible there may be a job left undeleted.

or Restart the sql services.

HTH

from

Killer

Hi Arun,

U can use sp_spaceused SP to get the available space left for the specified database.

Create a job and schedule it so that u can get the information on ur...

Hi,

Thanx for ur help.

from

Killer

Lot of information i got from web about the sysxlogins but still i dont understand why sa login have 3 records in sysxlogins table.

from

Killer

Hi Phill,

It is null in the syslogins table.But when i view the sysxlogin table it is not null.

and in sysxlogin table there are 3 records of login sa.

from

Killer

Hi,

Reindexing, delete,drop and many other statements are reason for log file growth.

If u dont want that logfile should grow then change the database recovery mode to simple.

But then u can not...

Hi,

Do not schedule the job u wanted to run after the first job.

U can check sysjobs and get the job id which is running as it will complete the success...

Hi,

U can run this code and dencrypt the view , trigger and sp

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

CREATE PROCEDURE DECRYPT2K (@objName varchar(50), @type char(1) )

 AS

DECLARE @a nvarchar(4000), @b-2 nvarchar(4000),...

Hi ,

To check about SSL from SQL Server

EXECUTE master.dbo.xp_regread N'HKEY_LOCAL_MACHINE',N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib', N'Encrypt'

if the return data value is 1 then it is already configured\installed.

HTH

from

Killer

Hi ,

How to enable SSL encryption for SQL Server 2000 with Certificate Server.

Pls see this link.

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

from

Killer