Search Results | SQL Server Performance Forums

xp_sendmail issue

Post by: jogin malathi, Nov 11, 2008 in forum: SQL Server 2005 General DBA Questions

xp_sendmail { [ @recipients= ] 'recipients [ ;...n ]' } [ ,[ @message= ] 'message' ] [ ,[ @query= ] 'query' ] [ ,[ @attachments= ]...

xp_sendmail issue

Thread by: jogin malathi, Nov 11, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

xp_sendmail: Procedure expects parameter @user, which was not supplied. Iam using following scriptEXEC master..xp_sendmail @recipients =...

Retrieve SQL Login password

Post by: jogin malathi, Nov 5, 2008 in forum: SQL Server 2005 General DBA Questions

Instead of changing is there any way to get Password..?

Retrieve SQL Login password

Thread by: jogin malathi, Nov 5, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, How can i retrieve SQL Login password. I can see login and password in syslogins tables. But password is hiked there.. Can someone please...

Distribution server name

Thread by: jogin malathi, Oct 30, 2008, 1 replies, in forum: SQL Server 2005 Replication

Hi.. How can I get distribution server name..Is there any system stored procs for this..

Failed jobs

Post by: jogin malathi, Oct 27, 2008 in forum: SQL Server 2005 General DBA Questions

We also have notification Tab for this.

Slowness on Database..Need to updtae statistics

Thread by: jogin malathi, Oct 21, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

What command i need to run to updtae databases statistics..

Linkserver details

Thread by: jogin malathi, Oct 13, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All,How can i get linkserver details, like i want to know linkserver creation date,etc...With sp_linkedservers i am getting only few details..

DB server role permissions

Thread by: jogin malathi, Sep 15, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi..How can i get database role permisisons on Particular database

List of users who have execute permissions on database

Thread by: jogin malathi, Sep 11, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All..Is there any way by which i can get list of all usersave EXECUTE permissiosn on database?

Login with other Window ID

Post by: jogin malathi, Aug 28, 2008 in forum: General DBA Questions

I tried this.. But when i user select user i see op as dbo but thsi is not the user i setted..

Lock Error

Post by: jogin malathi, Aug 28, 2008 in forum: SQL Server 2005 General DBA Questions

Exactly..

Lock Error

Thread by: jogin malathi, Aug 27, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

HI.. When i am trying to open tables on my SQL Management Studio..its throws an error saying Lock request time out period exceeded(Microsoft SQL...

Login with other Window ID

Thread by: jogin malathi, Aug 27, 2008, 6 replies, in forum: General DBA Questions

Hi... I need to check whether garnted user have permissions.. For example i granted Some read acces to XXX on particular database. Now i want to...

Droping added column on replication table

Thread by: jogin malathi, Aug 26, 2008, 1 replies, in forum: SQL Server 2005 Replication

Hi... What can someone correct if i am going in wrong way steps i am following to drop added column on replication table. Step1: Drop the subsribers...

performance

Thread by: jogin malathi, Jun 27, 2007, 1 replies, in forum: T-SQL Performance Tuning for Developers

from where one should start to check query performance Malathi Rao

Hash match

Thread by: jogin malathi, Jun 27, 2007, 1 replies, in forum: Getting Started

Hi all<br />In my query execution plan i find [b[<img src='/community/emoticons/emotion-4.gif' alt=':p' />]]Hash Match </b> <br />Iam Unable to...

query performance

Thread by: jogin malathi, Jun 25, 2007, 2 replies, in forum: Getting Started

hi all Iam practing the query performance Iam unable to understand that from where i should start Any one suggest me the steps to be followed to do...

Valid error number

Thread by: jogin malathi, Jun 11, 2007, 2 replies, in forum: Getting Started

hi all, Here iam creating alerts i want to raise alert when job executes for that their is a option called error number it asks for valid error...

Lazy spool

Thread by: jogin malathi, Jun 5, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

hi iam new to sql server DBA HERE IAM UNABLE TO IDENTIFY WHAT IS LAZY SPOOL I got this when iam trying with "DISPLAY ESTIMATED EXECUTION PLAN"...