Noel,

Thanks for your reply...I have tried shrinking the TLog with your method and it also works just fine so now I have two ways to shrink a log file while...

I wanted to post a final solution to the question I posed several weeks ago in case someelse has this problem...

To shrink a Transaction log for a database that is...

Noel,

I ran the command dbcc sqlperf(logspace) and found that the database I am concerned with is only using   5.49% of the log space.

I went to create a NULL device as...

Hey Mike...

Here are the steps I used to resolve my problem.

First I deleted the Maintenance plans under SSIS

Then I ran the following scripts:

URL: http://gedzuks.wordpress.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error/

Sql Server 2005 Delete Maintenance Plan Error

April...

Mike,

I went ahead and ran the sp_dropserver, sp_addserver hoping that would solve my problem.

Again unable to delete the maintenance plan.

Next I tried dropping/deleting the job as you suggested and I...

The variable was set to have scope on the entire package. When I ran the job it does not fail therefore the View History did not give me any detail...

Thanks Yelena to the quick reply...

I will try your solution this afternoon and let you know how it worked...Thanks again

Yelena,

I have implemented your solution...

Thanks David,

Now that you have pointed me in the right direction I have gone to several web sites where they deal with this subject in some detail. You have saved...

Just want to thank you guys for your responses, I tried the UDF route and it worked beautifully...Thanks very much Reg...

After exhaustive research I finally found a posting in a newsgroup on Microsofts web site for Report Services that mentioned a problem similar to the one I was having. MS...

Thanks John, I will go do some research and  see what I can find. Will post my results later...Thanks again...

Thanks Keith I will try your solution this morning...

Thanks to all who responded. I will see if I can get a copy of the application and see if tables are referenced via owner.table... again thanks for help Reg

...

quote:

---

I think ISS reads the ERRORLOG file looking for "Login succeeded for user" messages to keep track of the last time a...

quote:

---

No ideas how they produce the report. They might trace the logins by examining transaction log or using Profiler to trace who...