Viewing 15 posts - 31 through 45 (of 1,165 total)
Check the execution plan of both executions and see what is the difference...
It might be parameter sniffing issue...if it is then use RECOMPILE Query Hint to Solve Parameter Sniffing Problems...
June 2, 2008 at 12:45 pm
It is the same as regular server...
Change the service account and restart the sql services to take effect. you don't need to failover...just offline/online should be fine.
June 2, 2008 at 12:40 pm
Here is the MS article...
How to configure SQL Server to use more than 2 GB of physical memory
June 2, 2008 at 12:39 pm
Add the /3GB switch in BOOT.ini and enable AWE using SP_Configure...
June 2, 2008 at 12:38 pm
Insert the Restore Header only information into a table and check the latest backup and restore...
http://www.karaszi.com/SQLServer/util_restore_all_in_file.asp
June 2, 2008 at 12:35 pm
Take the sql services offline in cluster admin and start it sql in single user mode from command window to resolve the issue and follow the instruncations in the article...
June 2, 2008 at 12:28 pm
No, you see the replication agents in replication monitor...
These monitors execute the jobs...so you can stop and disable the job too...and you need to reenable and restart the job...after your...
May 30, 2008 at 5:27 pm
You can stop the replication agent too...
May 30, 2008 at 4:58 pm
Only option would be SQL trace (profiler) or check for third party tools...
May 30, 2008 at 4:48 pm
When you use sp_rev_login script to copy the logins it will generate the script of logins with passwords...means what ever the password at your source server the destination server will...
May 30, 2008 at 4:44 pm
You may need open a ticket with MS 🙂
If you have previous backup of this database, restore and see if there IS any problem...
Are you able able run the tlog...
May 30, 2008 at 4:41 pm
Did you run the procedure in the same db where you have the issue...?
May 30, 2008 at 4:04 pm
If you want to create a text file with procedure output then you can use SSIS or BCP or SQLCMD or osql too...
bcp "exec procedurename" queryout "file.txt" -T -c
May 30, 2008 at 3:54 pm
1. You can reapply sp2 if neccessary...
if you want to go back to sp1 follow the readme file instructions...
2. You can't drop the table when it is participating in replication...
May 30, 2008 at 3:48 pm
Viewing 15 posts - 31 through 45 (of 1,165 total)