The data is stored in your msdb database. Is this on all instances? Likely you have a client tool issue

I tend to agree with the two posts above. I separate things out for two reasons:

- security, you can secure things, but the more co-located things are, the more you're...

You are not "on your box" when you access the linked server. You've submitted a request to the server running on your box. You're allowing the service to connect to...

Works fine here, haven't heard anything on using an underscore. I do tend to avoid strange characters in identifiers, however.

Rules for identifiers: http://msdn.microsoft.com/en-us/library/ms175874.aspx

The execution plan isn't prepared ahead time. When you submit EXEC the second time, it checks to see if it has a plan for that exec string. If it does,...

There are wizards for both of these. If you have having issues, post a question on the specific issue. These are used for very different technologies used for different things.

An int will join quicker just because it's smaller, but in most systems, it is likely a negligible delay. Plenty of people use SSN, email, etc. as PKs and they...

Please don't cross post things. We see all the forums.

Once you have called the stored procedure, the output parameter comes out in @d and you can use that in a...

That looks interesting. Reminds me of ISO9001, which a couple companies I worked for adhered to. While it was annoying on day to day basis, I think it does...

I have heard some people having scale issues with the CLR procedures, and I've tried to ping NASDAQ, but no word yet.

I'd think that would bother NASDAQ, but most of...

Hiding your logic from clients is overrated. If that's all you're selling them with the software, you're not providing much service. Don't forget that you schema, the code oyu use,...

There's no way to do this I'm aware of right now. The iFTS indexing service in 2008 can index an Excel file, but I'm not sure you can consume it...

I think you'd want to set the trace to run at startup and then log to a table in a database that very, very few people (and not the DBAs)...

Fair point on the filing cabinet, but I think computer systems are expected to have better security. Also, the physical nature of notes tends to mean that you can protect...

This is directly reading from the DB. The command is sent to the server and then the server executes this.

You can set this up as a linked server, but you...