I have created a procedure that logs the blocking information on the server to a table.I have tested it by creating a blocking on QA using scripts .I...
In order to identify the blocking process iam writing procedure to log the info into a table ,I also need to log the command that was executing at...
Dear all, The command Exec Master..XP_CmdShell 'PStat' is not returning values for sishell sql user.For sa it is working fine ALL of the options for...
We have a HTML tool to remotely monitor the specs and performanc of the SERVER In that tool we have an option to check the MDAC version on the...
I have to transfer few tables from one server to another server.As in sql 2000 any import export tool exist in 2005 ? Thanks DBA SHAMS
Dear all, As per the request we need to read exchange server public folder and populate the info into sql server.Can some one help me on this. Can...
Dear all, I need to provide a user to view/create/edit/delete SQL jobs in SQL Server 2005. How to proceed on this . Thanks, DBA SHAMS
We have a user named dmuser and is ddl admin of the db in sql 2005.The user is not able to edit the table structure using mmc .A message was popping...
A new user was created and he needs to view the jobs .I removed the where clouse from msdb.sysjobsvies and it didnot worked out.Please suggest....
I have to configure G 256 switch on the server to dedicate 256 mb memory for ole processors in sql server.iS it is Boot .int file we need to...
sql agent log has several errors logged 1) logon to server(local) failed (job manager) 2) Login failed for sa 3) logon to server failed...
product sql 2000 Created a vb script to delete registry entries.created the package with administrator as the job owner .Ran the package and it...
When i tried to login to sql server 2005 with sa and windows autentication iam getting the below message " A CONNECTION WAS SUCCESSFULLY ESTABLISHED...
In sql 2000 the registry entry for registered servers are listed under "SoftwareMicrosoftMicrosoft SQL Server80ToolsSQLEWRegistered Servers XSQL...
Using query analyser I need to find out the owner of the job .THE out put should be in SQL USER NAMES AND NOT IDS pls suggest. Thanks, Jimmy...
I need to list out key values from registry .Tried exec master..xp_regenumvalues 'HKEY_Current_User','SoftwareMicrosoftMicrosoft SQL...
When i view the job history the recent onces are missing .But the jobs are running fine. The SQL AGENET WAs configures with 5000 rows for sql logs...
<br />Multiple instance of the below error are reported in sql logs and the sql server was recycled after these errors<br /><br />17066 :<br />SQL...
Dear all, I need to shedule a job that automatically check for any opened sql enterprice manager or registered query analyser that exist at...
Following error are logged in sql 2000 BobMgr::GetBuf: Bob write not complete after 60 seconds. SQL Server has encountered 4 occurrence(s) of IO...
Separate names with a comma.
