Viewing 15 posts - 661 through 675 (of 1,069 total)
This role exists in MSDB database.
Hope this tip helps you to fix the problem.
July 27, 2010 at 2:54 am
Check these:
dbo.sysmaintplan_plans
dbo.sysmaintplan_subplans
dbo.sysmaintplan_log
dbo.sysmaintplan_logdetail
July 13, 2010 at 6:26 am
Good explanation found in the BOL
This table is included in Microsoft SQL Server 2005 to preserve existing information for instances upgraded from a previous version of Microsoft SQL Server. SQL...
July 13, 2010 at 6:21 am
Is this instance restarted just before running this query?
Because when the instance is restarted, all the dmv values are reset.
Is database property AUTO_CLOSE = On?
June 30, 2010 at 6:17 am
Bhuvnesh (6/30/2010)
HiIn one of my sql instance i am not getting records for table/index updation in sys.dm_db_index_usage_stats DMV.
Please post the SQL query you are running.
June 30, 2010 at 5:55 am
Do you get any error when you run sys.dm_db_index_usage_stats?
Is the database compatibility level = 90?
Do you have any index (which is used) on this database?
June 30, 2010 at 5:47 am
David BAFFALEUF (6/22/2010)
May I suggest you to code the same logic in a SQL Agent job ? This is where you may have control on the arguments.David B.
I agree with...
June 29, 2010 at 10:30 pm
b38911 (6/29/2010)
Yes, this is useful for on-line checks...I'd like to automate the checks with a script or job....
Please check sp_replmonitor* stored procedures.
June 29, 2010 at 2:58 am
No. I don't have document (PDF/DOC files). I just referred SQL Server 2008 Books Online.
You can download SQL Server 2008 Upgrade Technical Reference Guide from Microsoft site.
June 27, 2010 at 10:26 pm
Asha.Richardson-1129890 (6/24/2010)
In our scenario, we always want to start our job from step #1 so that menu is a bit of an annoyance.
Forgive me if my question is silly....
June 25, 2010 at 4:51 am
MAK-1128556 (6/24/2010)
can I keep the subscrption on 2005 server and upgrade distributer and publisher to 2008:hehe:
I think you can.
Below are the two quotes from BOL:
When you replicate between or among...
June 25, 2010 at 12:45 am
Are you trying to install Visual Studio on a Server?
If yes, it is not recommended. As it is a client software. It should be installed on a PC.
June 24, 2010 at 6:02 am
monzulu (6/24/2010)
i want to copy the contents of table1 to table2 and "prune" table1 with only 1 occurence of each place......
thanks for any advice and suggestions.
SELECT ...UNION... also...
June 24, 2010 at 3:18 am
sjimmo (6/23/2010)
In these cases I partition the table itself, with data being placed on one physical drive and indexes on another.
Table partition (aka Horizontal partition) is quite different...
June 23, 2010 at 11:23 pm
Viewing 15 posts - 661 through 675 (of 1,069 total)