Hi Sarah,

I could not agree with Susila more. That is why we keep copies of some part of their production data at our local site on a designated Staging Server....

Yes Mr. Expert DBA, I got it alright!

If you are going to get dbo_permissions to the database, it is still not going to solve the problem. Look at all the...

It cannot be done. The backup has to run on the server where the database resides.

Are you trying to sneak a database on one of the servers onto you...

The problem lies in which account your SQL Agent and the SQL Server is running under. If I have understood the error correctly, they probably start under the 'LocalSystem' system (or...

Jon,

If I have understood you correctly, running a trace would not solve the problem. Firstly you will have to keep the trace running all the time the developers are working....

From what you have provided, it is difficult to give you any precise answer or help you in going in any particular direction. It is not always associated with just...

Resolved a similar issue of "across domains" just a couple days ago. The default gateway on one of the servers was incorrect.

Amrita,

To answer your question, it is possible to write something.

You can get the syntax of the view writting a simple query on SysComments. You can even search for a particular...

Try this:

"select 1 as [one] into #x from table_1 with (tablock, holdlock) option ( fast 1 ) "

This way:

1 - you directing the o/p to a temp table so you...

These are the two things I would to  look at first:

1 - Having an index on the ActionCode (and any other filter conditions you have). This will reduce the time...

Had similar problems before. If you haven't tried the following, I would try these things first:

1 - Ping both the servers from the other (domain or name resolution problem).

2 -...

Tammy,

From a cursory glance at your SQL statement I can guess that the root of the problem is that you have to go to different columns based on certain...

I absolutely agree with Frank. I had to write a script recently to collect information on all the properties of all the Linked Servers on a given server. To collect...

Barbara, in my opinion you should not worry about this message at all. This is a purely informational message. We get this message all the time.

You could see a corresponding...