Viewing 15 posts - 1,036 through 1,050 (of 2,462 total)
shaun.stuart (12/22/2011)
But also keep in mind that the transaction log for model will grow if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 22, 2011 at 10:57 pm
Although chances are less but there might be any query running on same tables which implies that this problem doesn't come up with every run. its just a blind shot...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 22, 2011 at 4:49 am
paul.knibbs (12/22/2011)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 22, 2011 at 1:36 am
This will help you. i guess your CLR functionality is disabled
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 11:02 pm
waseem.shahzad 45937 (12/19/2011)
I want to Monitor My SQL Server's Database events. Whenever there would be a change in My Schema,Execution of SP/Trigger/View/DDL/DML part>> The User's Machine Name emailed to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 10:55 pm
NJDave (12/20/2011)
Executed as user: SNJ282\SYSTEM.
What kind of privilege this account has ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 10:51 pm
logically, updating an index and doing backup doesn't suit as updated index should go into backup file.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 6:25 am
I am keen to know why model Db has huge log file. one thing comes to my mind : that we are putting some default/standard sql objects there which we...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 6:04 am
beejug1983 (12/19/2011)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 6:01 am
geetha@in (12/19/2011)
I want to stop my all services in server before going to reboot..
Why you want to stop the services?
(i assume all are set with "Automatic" option.they will get...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2011 at 5:56 am
All processes which are related with "Database Mail" are taking too much time.
Database Engine Instance=IN\DEV;Mail PID=8212;Error Message:
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: The connection is not open.
Data: System.Collections.ListDictionaryInternal
TargetSite: Void ValidateConnection()
HelpLink: NULL
Source:...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 18, 2011 at 1:43 am
Chris, it happened to be same.actually in morning i restarted the sql instance but strangely, i could see same spid still exist there.then i needed to restart the host.i know...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 17, 2011 at 1:58 am
GilaMonster (8/16/2011)
If you restart SQL (which is necessary to get it into single user mode), the rollback will continue after the rollback with the database unavailable (unless you have Enterprise...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2011 at 7:09 am
Additionally server is not behaving good.below is the error i am getting quite often.
SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2011 at 6:12 am
GilaMonster (8/16/2011)
That 0 seconds, 0% often means the rollback is stuck waiting for something, maybe DTC, maybe a resource in the DB. Check for that.
How to approach here ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 16, 2011 at 6:04 am
Viewing 15 posts - 1,036 through 1,050 (of 2,462 total)