Anyone has such video for Google Database Implementation? That will be still much interesting....

Hi,

Same is possible in Management Studio. Refer this MSDN article

http://msdn.microsoft.com/en-us/library/ms159699(SQL.90).aspx

Hi,

DBCC will not bring down the DB but it will block access... If your Databases are heavily utilized then it may created blocks!

Hi,

Is it Express Edition which you have installed?

Hi,

I have a doubt. Even Linked Server is using DTC right? Is it different from MS-DTC? Even we have only configured MSDTC for Transactional Replication with...

Hi,

Go to Subscriptions TAB and Click New Subscription and fill out details like below...

If you mean "How will we come to know that Database is Crashed?" then answer is

1. Run DBCC CHECKDB('DatabaseName') which checks for integrity of database and it reports error found.

Note:

This...

You already have the query you are looking for... Then what else you need??

Hi,

Since you have posted this in SQL 2005, you can use tip in below url to directly search between dates using xp_readerrorlog. Incase you are writing this...

You are welcome mike...

Hi,

Microsoft has article for your question

http://msdn.microsoft.com/en-us/library/ms345578.aspx

Hi,

You can use MoM from Microsoft for Monitoring. Incase you have licensing problems then create your own script. Check SQLServerCentral Scripting Section for lot of Monitoring Scripts.

If you...

Nice to see that it worked...

Option 1:

Try SQL 2008 Express which is free

Option 2:

Install SQL 2008 Client tools and connect to SQL 2005 and see whether intellisense works

Note:

Just ideas... Don't know whether either will...

Hi,

Just for clarification...

1. What is the Service account you are using?

2. Have you change service account settings using SQL Configuration Manager?

3. Both the nodes are installed with...