Jack is right, try backup to a different disk or a server in your network.

igngua (12/4/2009)

---

I didn´t get how tu use trim function.

I have a col with data and i need to erase all blank spaces to the right of the string.

thanks in...

Weekend 🙂

Such names are generated in Database Engine Tuning Advisor when a query workload is given to tune. The recommendations from DTA are in that fashion and some users just use...

Bob Hovious 24601 (12/4/2009)

---

I thought it was Lloyd Bridges.

Bru: Lynn is correct.

If I post something that seems...

Follow this article http://support.microsoft.com/kb/307487

Remember, restarting your SQL Server means its a down time for your application using that Instance, so be aware of that.

If it has grown to that size, it...

Gus...

Hey guys, this user needs help in solving the issue. It's been 2 days since he posted and no good.

http://www.sqlservercentral.com/Forums/Topic827900-357-1.aspx#bm827908

SA has highest security permissions on an instance. Any way where are you looking at SA having no permissions on MSDB ?

jez.lisle (12/4/2009)

---

my problem is that my Live server is on SQL Server 2005 Standard edition always tells me when I name my publication that it cant publish the database as...

In that case, check if the user account under which the Job is executing, has sufficient permissions on MSDB.

When you run manually, it succeeds since it executes under your security...

Have you thought about dropping that article (table) from the publication (which is Transactional Replication) and create a new publication (transactional Replication with updatable subscriptions) with this article (table).

In short,...

Did you see anything mentioned about the step (maintenance plan step) in the Job history?

If it reports an error, post what is it?

It would be nice to start with a Developer Edition (Couple of days back I suggested Evaluation edition and got bruised) 😛

Make a decision on what you are interested more...