The new drive you have added to your system (Y Drive) is not yest added to the SQL Server Resource. If you have seen what Gail Shaw has replied, that...

Look at the link to my personal Blogs, and look at the Blog posted yesterday. That is the starting point, I am using a 5 mins interval at my work...

:-P;-):w00t::cool::hehe:

All the 5 tips will make a better SQL Server Developer

If the...

cooldude (12/2/2009)

---

no its an database user

he was connected and i granted him view definition permissions for views and he had to disconnect and reconnect for them to show up

It...

Is the user connecting through an application?

Not 100% sure about connecting from application, but I don't think the user needs to reconnect

To confirm, I tried now through SSMS...

Follow the link, where the problem was also about Log file growing too large to handle.

http://www.sqlservercentral.com/Forums/Topic826361-146-1.aspx

Regarding changing the recovery model of the Database, I don't think it would allow while...

Please find this technet article on Database Mirroring.

http://technet.microsoft.com/en-us/library/cc917680.aspx

The OP was having problem in Import / Export wizard.... not DTS or SSIS Package.. 😉

Having Master DB as 7 GB in size is really bad. You can use DBCC SHRINKDATABASE to reclaim the space to the OS.

If you feel it is simple explain it clearly, so that the OP can...

If SQL Server indicates it is SP2, then it must be true, plan for installing SP3.

Look at the SQL Server error log and post the error message(s) here.

GilaMonster (12/2/2009)

---

You missed what happened over Thanksgiving weekend. On the friday that guy had posted to over 20 threads with exactly the same message, even threads that weren't related to...

What is the current autogrowth settings for your DB files?