Viewing 15 posts - 961 through 975 (of 2,462 total)
u need to setup linked server for "ServerM"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 14, 2012 at 12:07 am
but right now. In Production databases, Log files used to be 60-100 MB before but right now it increases upto 14 GB.
so I try that command above manually and I...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2012 at 8:41 pm
below query can help you to list down all db for backup but you need to cutomize your current scripts
declare @tbl_backup_list table (id int identity ,[db_name] nvarchar(200))
insert into @tbl_backup_list
select...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2012 at 8:34 pm
GRANT VIEW SERVER STATE TO <<login name>>
This will grant <<login_name>> VIEW ANY STATE permission.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2012 at 7:59 pm
homebrew01 (5/11/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2012 at 10:03 am
durai nagarajan (5/11/2012)
NT AUTHORITY\NETWORK SERVICENT AUTHORITY\SYSTEM
ServerName\SQLServer2005MSFTEUser$ServerName$MSSQLSERVER
ServerName\SQLServer2005MSSQLUser$ServerName$MSSQLSERVER
ServerName\SQLServer2005SQLAgentUser$ServerName$MSSQLSERVER
does the mentioned users should have access to connect to SQLserver or shall i remove them.
if access needed what access should i need to configure.
i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 11, 2012 at 9:59 am
Nagendra Rao (5/10/2012)
I have the same problem. Can you please tell me what Network issue you had. In my case,
1. I am able to navigate from my SQL...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2012 at 10:33 pm
set the sql profiler and trace the lock and deadlock there.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 9, 2012 at 11:14 pm
it will be get reflected automatically to all the area/section wherever used.
but haven't you hard coded rthe password anywhere ?
have you checked the job history for error ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 9, 2012 at 11:11 pm
mike schreiner (5/9/2012)
5.Go to the Binn directory of the SQL Server instance. In this case it was d:\Program Files\Microsoft SQL Server\MSSQL10_50.AFVCSQLSERVER01\MSSQL\Binn
6.In...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 9, 2012 at 9:43 pm
Set trace on performance monitor see if there are high IO spikes
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 8, 2012 at 6:30 am
capn.hector (5/7/2012)what i expected to hear. what im figuring is one delete occurred the other got rolled back which caused the issue. thanks for the help.
It...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 8, 2012 at 1:56 am
.Netter (5/7/2012)I understand what every one has written and i appreciate your time on this subject, but my point was if im not going to use them columns then why...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 8, 2012 at 1:37 am
Having separate users can help you to track and restrict their usage or activities.If you are using SQL 2008R2, resource governor can help you to manage resources usage for every...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 7, 2012 at 2:43 am
you can keep your historical /old data on other disk by setting some archival job(hourly basis or may be trigger) and later use these two different tables to fetch current...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 7, 2012 at 2:38 am
Viewing 15 posts - 961 through 975 (of 2,462 total)