Viewing 15 posts - 706 through 720 (of 1,079 total)
try:
http://support.microsoft.com/kb/246133
should sort you out...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 26, 2010 at 11:42 pm
GilaMonster (7/22/2010)
Henrico Bekker (7/22/2010)
Do not use row and table locks.How would not using locks prevent dirty reads? You suggesting page locks only?
tsk...I meant WITH NOLOCK...my bad.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 6:38 am
talla.rishi (7/22/2010)
Error message :-
Rule check Result
Rule " Cluster share disk available check " Failed .
The Cluster on this computer does not have a shared...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 3:55 am
set nocount on
use at the start of your query/statement
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 3:49 am
gaurav-404321 (7/22/2010)
Also i want to generate the insert script for table data rows...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 3:01 am
We are currently using SQL Server 2005 on a VM
Go with tin or...
Have a look at your indexes....this scenario sounds ideal for fragmentation....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 2:58 am
gaurav-404321 (7/22/2010)
can u plz guide step by step how to do that
Right click the object, select Script Database/Table/etc -> Create to (select your wanted option)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 2:57 am
gaurav-404321 (7/22/2010)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 1:38 am
Do not use WITH NOLOCK on rows and tables.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 22, 2010 at 1:37 am
Since there are shared components, you'll have to be very careful what you delete.
SQL Server registry entries will still be present, and can be removed if you are absolutely sure.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 20, 2010 at 6:40 am
Whoa! sorry for my bad advice there, and thank you to Gail for setting me straight.
I learned from it as well.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 19, 2010 at 5:55 am
Full Backup included the Databases as well as the log.
You can backup the log if you need to be able to restore to a certain point in time.
Read up on...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 19, 2010 at 5:07 am
No, you cant, you will confuse SQL and your LSN sequence.
The Maint1 log backups will fail if you do a second full backup in between.
Differential will also be based on...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 19, 2010 at 4:32 am
Yes, you need to....
Your configurations, logins and jobs are stored in the master and msdb databases.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 19, 2010 at 3:49 am
Dave Ballantyne (7/16/2010)
Here's the best option
LOL!, good one.... 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 16, 2010 at 1:58 am
Viewing 15 posts - 706 through 720 (of 1,079 total)