This is where powershell comes in very handy. Right-click on the database node in object explorer and open powershell - once there you can issue the following:

PS> Get-ChildItem |...

You are welcome - thank you for the feedback.

How did you move the logins to the new server?

If you just created them manually, or ran a script that created them - then you probably have orphaned users.

Run the...

Oh - one more thing, use the catalog views:

sys.trace_columns

sys.trace_events

sys.trace_categories

sys.trace_event_bindings

sys.trace_subclass_values

With the above, you can convert the internal column/event id's to their external values.

You can replace the function fn_trace_getinfo with:

SELECT * FROM sys.traces;

To get more information about the traces running, use the following functions:

fn_trace_getfilterinfo

fn_trace_geteventinfo

Matt Miller (#4) (4/28/2010)

---

How is len going to be affected by either of those settings? I...

What have you tried so far? Lookup database_principals and server_principals in books online.

It sounds like you have a problem with the network between the servers. When backing up across the network the backup file is being corrupted.

Unless you can guarantee your...

Okay, then you really need to review the article on managing transaction logs that I link to in my signature. Either you are not actually...

My recommendation is to not shrink the databases - as I said before, it is just a waste of time.

That should fix the problem - unless there are other jobs doing the same thing.

bilex7226 (4/27/2010)

---

New problem, when I navigate to the URL it's prompting for a user name and password. Any ideas or pointers. I have not found anything out there that has...

You should not have had to do that - but it shouldn't be a problem.

Lowell (4/26/2010)

---

i had a little trouble reading what you wanted, but i think i got it.

1. you want to create a view for every table in the database, but exclude...

There is nothing in that script that would cause the issue you are having. It has to be some other script that is breaking the log chain.

Two questions:

1) Why...