thanks for the reply...but my tempdb isn't full at all..i still have 7 gb of free space...As of now my tempdb size is just 800MB & has around 400+...
After restarting the production server, our stored proc. seems to executing at the normal speed what we are see in Dev & UAT servers....
thanks for reply.
Got it, When i used Dbcc updateusage with Count_rows it works.
Why does Count(*) and sp_spaceused rows count is different for some tables?
I used Dbcc updatausage to corrects pages and row count inaccuracies ,...
I tried to reset the replication status in sys.databases using
sp_repldone, but still it's shows up .
Do we have any other options...
Thanks for the reply. I want know why log wait desc in sys.database is marked as replication even though my snapshot replication compelted...
Periodically my SQL 2005 snapshot publication database starts to grow it's log
file without truncating.
- The recovery model is 'simple'
I have a column reportdefn defined as xml in a table AdhocPivotTableReport<br />Values in the table is as shown below:<br /><br /><xml xmlns<img...
Got it.... Startup account doesn't have enough rights to read the directory.
This are the error i getting when starting the sqlserver<br /><br />FCB:<img src='/community/emoticons/emotion-3.gif' alt=':O' />pen: Operating...
I moved the tempdb data & log file to different location from where it was installed & then i copied the data & log to that destination...
I have table with data as shown below
id entityid rolecodeid
Thanks for reply..
I have a question on Distribution database.
There are couple of tables MSrepl_commands(more than 20 millon rows) and Msrepl_transactions(more than...
I didn't enable it again...i don't think i need that...microsoft is going to remove that option .
As of now it working without any problem
In server configuration option 'remote proc trans' was turned on. Went & turned off the option. It works.
i am able to create local distributor ..that works fine..only the local pub with remote dist fails.
We have 2 servers ,sqlserver 2005 on windows...
i tried restarting the sqlserver also...i still get the error...
i am able to do transaction replication with push subscriber with dist in the same...
yes..i did..there is nothing open..there is no wait for status also if u ran sp_who2
Separate names with a comma.