Viewing 15 posts - 286 through 300 (of 2,462 total)
see this http://www.johnsansom.com/the-database-administrators-primary-responsibility/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 12:30 am
sqldban (3/5/2013)
But synchronization not happening.i don't understand what was the problem.
have you checkedt he statuses of morrored databases ? are they showing ("mirrored synchrnoized restoring...") ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 12:23 am
post the expected output based on your above data's example
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 12:19 am
komal145 (3/6/2013)
when I delete , I don't want to affect the identity columns, how can we do it?
Can you elaborate this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 12:18 am
Thanks for this LATEST reply but this is 2 years old thread 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 12:13 am
First of all, in my 4 years of log relationship with SSC, i havent seen any newbie writing such a long post :-D.it clearly showing that you know that what...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 12:10 am
Bhuvnesh (3/6/2013)
SELECT * FROM msdb.dbo.sysmail_event_log ;
Have you used this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 2:18 am
Please provide expected output too here with respect to the any effective date (from you sample data)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 1:01 am
Another thing,
send a test mail to investigate the point of failure.
Right click database mail –View database mail log to see error or we can SELECT * FROM msdb.dbo.sysmail_event_log...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 12:59 am
I recommend that you use Database Mail Configuration Wizard, the Database Mail Configuration Wizard provides a convenient way to manage Database Mail configuration objects and enables Database Mail.
For more...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 12:50 am
this can put more light here
CREATE LOGIN login1 WITH PASSWORD = 'J345#$)thb';
CREATE LOGIN login2 WITH PASSWORD = 'Uor80$23b';
GO
CREATE USER user1 FOR LOGIN login1;
CREATE USER user2 FOR LOGIN login2;
GO
begin tran...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 12:22 am
select 'ALTER DATABASE ' + Name + ' SET AUTO_UPDATE_STATISTICS OFF ' from sys.databases where database_id > 4
Copy the result of above query in run window and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 11:43 pm
In simple words.
Key/RID lookup means Non-clustered index is not covering all the participated columns in one query for one particular table. so optimizer choose the heap(RID) or clustered index(Key) for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 11:39 pm
winmansoft (3/5/2013)
Bhuvnesh (3/5/2013)
winmansoft (3/5/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 3:53 am
winmansoft (3/5/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 3:42 am
Viewing 15 posts - 286 through 300 (of 2,462 total)