This sounds like one where you should be calling CSS.

I've never seen Target Server Memory go to 0. FOr total server memory you should look in the error log to see if there is a message liek this,...

Simple answer is defragmenting indexes does not require downtime, but unless you are on enterprise edition and use the ONLINE option rebuilding an index is blocking. In addition to blocking...

Evil Kraig F (1/31/2012)

A robot DBA may not injure data or, through inaction, allow data to come to harm.

A robot DBA must obey the orders given to it...

I agree especially when...

I mentioned the computed column because I wasn't sure if it needed to be writable.

I'll have to play around a bit with the sample code to see how...

Have you seen this article, http://support.microsoft.com/kb/811889?

Based on what you have described it doesn't sound like a double-hop problem because the user is connecting directly from their PC to the SQL...

Is SQL Agent running? I've seen this get shut down or not set to auto start.

Sound like they want a model of the database. You can use the database diagram ability in SSMS, but then you'd need to either create an image of the...

A couple of things.

First, Paul, why an INSTEAD OF TRIGGER? I'm assuming that will have some performance benefit over an AFTER trigger.

Secondly, since the CBM2 column is...

It looks to me like this is a byproduct of running it in BIDS. When you open the package in BIDS it creates the first log file and then...

Off the top of my head I'd handle this in the .NET application by having a connection for the membershipDB and then a connection for the application DB. The...

As I said earlier you can't use a function...

Wish I could be of more help, but I don't see anything out of the ordinary in the package and have never experienced this problem.

If it is still set with EncryptSensitiveWIthPassword then that would be why I can't open it. You mention that in your first post.