xp_sendmail: Procedure expects parameter @user, which was not supplied.
Iam using following scriptEXEC
master..xp_sendmail @recipients =...
How can i retrieve SQL Login password.
I can see login and password in syslogins tables.
But password is hiked there..
Can someone please...
How can I get distribution server name..Is there any system stored procs for this..
What command i need to run to updtae databases statistics..
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..
Hi..How can i get database role permisisons on Particular database
Hi All..Is there any way by which i can get list of all usersave EXECUTE permissiosn on database?
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...
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...
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...
from where one should start to check query performance
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...
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...
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...
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"...
Separate names with a comma.