Viewing 15 posts - 901 through 915 (of 1,157 total)
Since you have already installed Client Tools on the Passive node, you need not do it again.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 11:13 pm
I am not aware of any such tools.The requirement varies case by case
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 10:59 pm
select * from 2000server.thidb.dbo.thistable - this doesnt work
FJM
Is thidb the default database for the account which is used in linked server? Also does the login has access to that database?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 1:28 pm
A reboot is required after applying SP3. You need not stop any SQL related services before applying the Sp3.
You need to install the SP3 on the passive node in...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 1:11 pm
The database backup cannot be taken amidst a transaction, like in trigger.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 12:56 pm
Can you please post the SSIS package and the job script?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 12:49 pm
Did you try changing the service account of "Performance Logs and Alerts" service? May be you can try starting it with the SQL Server service account.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 12:47 pm
Please post the Screen shot or the script of the job you are trying to execute. Also let us know while executing which task you get this error.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 12:40 pm
What is the problem and the related error messages?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 10:41 am
Please do it for the system databases except tempdb !
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 10:15 am
osql /E /SSTCSQL /dDB_PROD /h-1 /b /Q"set nocount on select getdate(), 'F4111 ',count(*) from [PDDTA].[F4111] WHERE (ILMCU LIKE '% 242%') OR (ILMCU LIKE '% 241%') OR (ILMCU LIKE '% 232%')"...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 10:11 am
No problem. Yes please go ahead with it
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 9:50 am
Check Database Integrity (should I include indexes?)
Please include indexes
Shrink Database(do I need to do it?, if yes I...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 9:19 am
You may want to consider re-indexing table by table. Between two re-indexes you can also give a wait time of a minute or so. Also you can fire a transaction...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 9:12 am
I second that. sys.servers should give you the details.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 8:21 am
Viewing 15 posts - 901 through 915 (of 1,157 total)