Viewing 15 posts - 601 through 615 (of 1,079 total)
Does this mean that we cannot control the behaviour from SQL side .?
Is there something like with "no lock" hint which can be part of the query ..?
You can control...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 30, 2010 at 12:55 am
Yes, the account needs msdb access roles as well, SQLAgentOperatorRole.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 30, 2010 at 12:52 am
This will solely rely on the way your DB2 environment and transactions are setup.
Normally it would only read committed transactions. If you DB2 tables and transactions are setup to not...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 29, 2010 at 11:11 pm
Error string: Error at Destination for Row number 73571.
You data pump succeeds up till the row indicated.
Inspect any form of transformation needed from source to destination and confirm if the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 29, 2010 at 10:19 pm
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 28, 2010 at 10:23 pm
do you have sufficient access to write to the destination location?
Try to restore a backup and see what errors are generated.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 24, 2010 at 1:26 am
http://msdn.microsoft.com/en-us/library/ms188902.aspx
investigate the files in you backup....use the link above..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 23, 2010 at 11:59 pm
Happy Holidays everyone, drive safe wherever you go, treasure the time with your families.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 23, 2010 at 11:54 pm
You can make use of the SP_help_revlogin as well, works quite well....
http://support.microsoft.com/kb/918992
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 17, 2010 at 1:52 am
http://lmgtfy.com/?q=differences+between+sql+2005+and+sql+2008
or
or
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 16, 2010 at 11:22 pm
USE master
GO
EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft
SQL Server\xxx\Registration','CD_KEY'
replace xxx with you 100 or 90....
Sorry, just remembered this SP was dropped...
wont work.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 14, 2010 at 5:29 am
Any reindexing/index rebuilts or maintenance plans?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 12, 2010 at 10:45 pm
Use the built-in ETL tool....
Right click your destination database and select Tasks, Import Data...follow the steps.....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 10, 2010 at 12:34 am
Duplicate Post.
All replies here: http://www.sqlservercentral.com/Forums/Topic1032840-1292-1.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 10, 2010 at 12:32 am
Abdul Walele (12/9/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
December 9, 2010 at 1:49 am
Viewing 15 posts - 601 through 615 (of 1,079 total)