Are you receiving a specific error message? I had this error today. The error message was along the lines "A network-related error or instance-specific error occurred while establishing...

The FROM was a generic email account. BUT I figured out why it was so hard to track down. When 'Notifications' SQL Agent properties is not used to...

Actually, my initial post didn't make sense so here's an updated one.

First off I'd try using a date format that includes a timestamp. So instead of CONVERT(VARCHAR(20),GETDATE(),112) , I'd...

It sounds like your local machine is running SQL 2008 R2 whereas the database server that you're connecting to is running SQL 2000.

Not too sure if you can use SQL...

Jasona is right. And to add a bit more, if you're not using the Express version, you do need to be a member of the sysadmin role.

Try the link below to start with. There's more you can do but this intro will get you started. Have fun!

http://technet.microsoft.com/en-us/sqlserver/Video/dd430301

Thanks for the links.

Thank you all.

Thanks Steveb. There seems tobe very little documentation for TFS out there. I think it'll be a process of trial and error all the way. 🙂

You got it. You'll need to convert to varchar(max) or nvarchar(max).

Logically I see no reason why you can't back up your service master key at any time but I can't find any written documentation to support it so you may...

Awesome! Nor change stuff at 4:30pm on a weekday

Because:

1) the capacity that this view will serve is...

Thanks for all the responses. I'll look for an option to do this from a stored procedure.

I get a syntax error. Doesn't like where I placed the 'OPEN'.