Viewing 15 posts - 2,146 through 2,160 (of 2,462 total)
Can you post exact Error you got ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 4:26 am
Read below posts
http://www.connectionstrings.com/sql-server-2005#p111
http://authors.aspalliance.com/aspxtreme/sys/data/sqlclient/SqlConnectionClassConnectionString.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 2:19 am
gupta1282 (3/3/2010)
What is Difference between both and which is better
You need some homework buddy:-)
Read below post
http://www.sqlservercentral.com/Forums/Topic286477-92-1.aspx
http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/086923c4-92c5-4d85-9cea-578dd097b118
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 2:11 am
Few questions :
Are both the instances on same machine?
Are you trying to implement mirroring first time on them ?
Have you tried Wizard for mirroring ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 2:03 am
Bhuvnesh (3/3/2010)
mike mcneer (3/2/2010)
Maybe SQL is detecting some type of corruption and is kicking of the dbcc checkdb to verify consistency.
Can it be possible that Sql server automatically run DBCC...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 12:39 am
mike mcneer (3/2/2010)
Maybe SQL is detecting some type of corruption and is kicking of the dbcc checkdb to verify consistency.
Can it be possible that Sql server automatically run DBCC Checkdb...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 12:34 am
RBarryYoung (3/2/2010)[hrthis would all be a lot easier and simpler if you did this in a set-based way
I didnt get you here ? any example ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 10:12 pm
DECLARE MC CURSOR READ_ONLY FOR
SELECT [Str]FROM #Windows_Auth_Orphan_User
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 7:38 am
blue_inelush (3/2/2010)
In order to avoid this, my understanding is that I have to run manually from time to time a shrink operation.
Well if it works for you. you can...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 6:08 am
then try to work with ALZDBA first post but with secure hands and watchful eyes. see if it can help you
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 5:51 am
blue_inelush (3/2/2010)
the .ldf file was constantly at a small size(at the log backups it was decreasing without making any shrink!!!!).
Do you have any maintenance plan or (job running periodically )...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 5:00 am
can u tell me how much space recovered in weekends and how can u say that it didnt work today(didnt u find any shrinking in log not even in MB...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 4:48 am
When you try to shrink a transaction log file that has little free space in SQL Server 2005, you may have to perform an additional log backup operation. The additional...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 4:21 am
parthi-1705 (3/1/2010)
HiWhich is good Sub query or Joins ?
Thanks
Pathi
i did some testing like convert your table variable into temp table and placed clustered index on RID.
and see execution...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 2, 2010 at 3:39 am
No , this is same but i also tried to changes user name like
i rename DB\XXX with BK but still select suser_name() gives DB\XXX
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 26, 2010 at 6:57 am
Viewing 15 posts - 2,146 through 2,160 (of 2,462 total)