What about Analysis services?

you need to grant the permission to stored procedures so that they can view the content of procedure

if there anre n number of procedures

select

'grant...

Change the network service account to a domain account in both the servers. This is because of hop issue.

With db_datareader they will be able to read the data in the tables only if you need to give them permission to see the procedure you have to give view...

But i have one question is it safer to shrink a logfile that is being used in log shipping or DB Mirroring it is not that wayso be careful on...

Just posting the error

Temporary table tempdb.SQLerrorTracking created.

Create database part starting...

Database DPIN does not exist.

.Net SqlClient Data Provider: Msg 1038, Level 15, State 1, Line 1

An object or column name...

Good that you have implemented the copy job across two locations so that even if it fails in one location it will be available in the other a case of...

I have always gone with my way og naming conventions but hve the habit of documneting them and putting it under a place accessible to all. By that way you...

Servername,portnumber

should do for you.

In your case it should be SQL2005,14333

Looking at the Activity Monitor first thing Monday morning did have a suspended process (Database Mail delete command - BROKER_RECEIVE_WAITFOR) but that has now cleared. And everything seems to be...

Congrats!!!!!!!!!!!!!!

The autogrows expands the file when it reaches the maximum sizt that can be stored in the file suppose let us have a datafile which is 900MB and you have...

That phrase is my favourite in this Industry i add to my signatures everywhere.

We do have a script for us here. Let me know your id so that i shall share it to you.