I believe, although not positive, you can reset your encryption key and then you just have to go back in and reset the credentials for your data sources, not recreate...

Can you ping the SQL server from the command prompt?

Can you connect using sqlcmd? From a command prompt like this:

sqlcmd -S [server name] -E

The -E is integrated security

Is this the transmission queue or the receiving queue?

It sounds like your process isn't ending conversations.

Most of the meetings I attend I would categorize as "Meeting Badly". There is usually a good reason and a need for the meeting, but the meetings are not...

You can try to identify the queries that are causing hashes and sorts and tune them. There may be query and/or index changes you can make to reduce hashes...

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

/RANT ON

Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of something...

waseemshaikh345 (6/18/2014)

---

Thanks corbet, I showed the client that way as well. The thing that sucks is they don't want it like that because the format is not the way they...

Well that's a pisser. Especially since my answer is using a method the OP says...

I'd use a query something like this:

SELECT

size * 8 / 1024.0 -

FILEPROPERTY(database_files.name, 'SpaceUsed') * 8.0 / 1024 AS free_space_mb

FROM

...

I'm not superman at this, but it doesn't look like your server is under memory pressure based on what you have provided.

What is the trend for Page Life Expectancy (shows...

First I'd change the query to return the data differently and then use the tablix as a matrix to pivot the results in the report.

I'd change the query to something...

I think you are looking for something like this:

CREATE TRIGGER [dbo].[chat_trigger] ON [test].[dbo].[chat]

AFTER UPDATE

AS

BEGIN;

SET NOCOUNT ON;

...

This probably isn't ideal, but I think it could work. You could either add a second EE session or a second target to your existing EE session using the...

Wow, I'm amazed at all the folks that have dishwashers at work. The only time I've ever had one was when I was working from home full-time.

My current job...

Does the file already exist in the remote location?