There are too many people to congratulate individually.

Well done everyone on making SSC THE SQL resource on the net.

:w00t::D:Whistling::smooooth::w00t::D:Whistling::smooooth::w00t::D:Whistling::smooooth::w00t::D:Whistling::smooooth:

Looks pretty familiar.

http://www.sqlservercentral.com/articles/Stored+Procedures/capturingtheerrordescriptioninastoredprocedure/1342/[/url]

Why you would want to do this in VB and SQL Server is beyond me. Like Jeff says, you don't need to go anywhere near the database for the functionality...

These statements sort of indicate to me that the OP doesn't understand...

I'd like to put in a plug for Hyperbac (www.hyperbac.com). It's made by the original developers of Litespeed.

Massive advantage is you just use any normal backup method within SQL Server...

This is one of the many known bugs with Maintenance Plans.

There is a patch for this issue, not entirely sure which one though.

Personally, I try and remove Maintenance Plans...

You won't be able to directly monitor the free space of a share within SQL Server.

What you could do is create a Performance Counter Log to record the appropriate free...

Not sure if you've got the right wording there, but it does look impressive 😀

Basically, to bifurcate is to split. Not sure what you'd be wanting to split your memory...

You really only need to check @@FETCH_STATUS = 0, that indicates that a row was successfully fetched.

Lorenzo DBA (11/7/2008)

---

When backing up all the databases via (1) process, I have found that if in any event that a backup of (1) database out of many fails for...

With your exclusion/inclusion of system databases, what about the distribution, ReportServer and ReportServerTempDB databases?

After making the point about having backups to avoid the risk...

All you need is IP connectivity at the OS level.

The limitation of using FQDN's is just the GUI.

No you don't, using IP addresses works just as well as using FQDN.

Firstly, check your ip connectivity between the servers. If you have connectivity issues you may need to update the hosts file with the ip addresses of the other servers.

Secondly, all...

Ughhh .... try a re-write without a loop and you might get some performance.

http://philcart.blogspot.com/2007/06/split-function.html