Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Archives: January 2013

How to find/modify SQLServer Agent logfile location?

1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out

DECLARE @AGENT_ERRORLOG NVARCHAR(255)

EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,

N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,

N’ERRORLOGFILE’,

@AGENT_ERRORLOG OUTPUT,

N’NO_OUTPUT’

SELECT @@SERVERNAME SERVERNAME, @AGENT_ERRORLOG AGENTERRORLOGLOCATION

This command will work for both default & named instance.

2. To modify location and name of SQLServer… Read more

2 comments, 1,165 reads

Posted in MSSQLFUN on 31 January 2013

SQL Server Silent unattended installation using configuration file

1) Open Installation Wizard

Open Installation Wizard

2) Select Feature You want to install

Select Feature You want to install

3) Provide installation configuration

Provide installation configuration

4) Now that you have the configuration file, copy it to your own folder or network share where you want to start the… Read more

8 comments, 982 reads

Posted in MSSQLFUN on 29 January 2013

Cumulative Update – 2 for SQL Server 2012 Service Pack 1 Is Now Available !

The 2nd cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can plan to test CU2 in test environment… Read more

0 comments, 644 reads

Posted in MSSQLFUN on 26 January 2013

Cumulative Update – 9 for SQL Server 2008 Service Pack 3 Is Now Available !

The 9th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 9 contains all the hotfixes released since the initial release of SQL Server 2008 SP3.

Those who are facing severe issues with their environment, they can plan to test CU9 in test environment… Read more

0 comments, 709 reads

Posted in MSSQLFUN on 23 January 2013

SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?

Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm that SQL Server really Reserve 1 user connection for DAC (Dedicated Administrator Connection).

So I decide to show a demo for the same. I have changed the no. of… Read more

3 comments, 378 reads

Posted in MSSQLFUN on 21 January 2013

Reminder about your invitation from Rohit Garg – MCTS, Microsoft Community Contributor

This is a reminder that on January 14, Rohit Garg – MCTS, Microsoft Community Contributor sent you an invitation to become part of their professional network at LinkedIn.

Accept Rohit Garg – MCTS, Microsoft Community Contributor’s Invitation
On January 14, Rohit Garg – MCTS, Microsoft Community Contributor wrote:

> To:…

Read more

0 comments, 407 reads

Posted in MSSQLFUN on 21 January 2013

The server principal “xxxx” is not able to access the database “msdb” under the current security context.

Problem :

Yesterday Night, One of my team member called & report that some users are getting below error no. 1 while connection to SQL server & error no. 2 while trying to open Management folder.

Error 1 : Cannot display policy health state at the server level, because the… Read more

4 comments, 4,230 reads

Posted in MSSQLFUN on 15 January 2013

Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?

Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account or SQL Agent Job Owner ?

Normally, We think its SQL Agent Service account user under which SQL jobs runs. But it’s not true in all cases, It depend on… Read more

3 comments, 799 reads

Posted in MSSQLFUN on 11 January 2013

The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.

Reblogged from MSSQLFUN:

Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB but whenever user try to run SQL Agent job, it get below error message.

We have Checked that SQL Agent job related DB role is properly…

Read more

1 comments, 312 reads

Posted in MSSQLFUN on 9 January 2013

The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.

Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB but whenever user try to run SQL Agent job, it get below error message.

We have Checked that SQL Agent job related DB role is properly given to user.… Read more

17 comments, 2,532 reads

Posted in MSSQLFUN on 9 January 2013

How to move file through FTP by CMD ?

CMD code to upload file direct into root of FTP site of server

@ echo off

REM ******** this batch file is to upload file

echo user username> ftpcmd.dat

echo password>> ftpcmd.dat

echo bin>> ftpcmd.dat

echo lcd D:\Filelocation>>ftpcmd.dat

echo put filename.csv>> ftpcmd.dat

echo quit>> ftpcmd.dat

ftp -n -s:ftpcmd.dat 172.xx.xx.xxx

del… Read more

3 comments, 612 reads

Posted in MSSQLFUN on 7 January 2013

What happen, If SQL Server new instance try to use exitsing named instance name?

We all know that SQL Server can have 1 default instance & many named instance.

But I want to check, How SQL Server Setup behave, If I tries to use instance name that is already being used by some existing SQL server on my system.

I am already having 2… Read more

7 comments, 610 reads

Posted in MSSQLFUN on 4 January 2013

MSSQLFUN – Year 2012 Review

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

600 people reached the top of Mt. Everest in 2012. This blog got about 2,000 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have…

Read more

8 comments, 395 reads

Posted in MSSQLFUN on 3 January 2013