Pulivarthi Sasidhar (7/8/2014)

---

DBCC SHRINKFILE: Page 3:48 could not be moved because it is a work table page.

Msg 2555, Level 16, State 1, Line 2

Cannot move all contents of file "tempdev1"...

It would be very helpfull if you can give us some sample data and the desired result.

See this link on how to post sample data: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Use this command to empty the contents of the file. Only when the file is not used it can be removed.

DBCC SHRINKFILE (N'{datafile_name}' , EMPTYFILE)

You can also just remove the...

I would prefer to execute the healthcheck locally by means of a SQL job and store the results in a table. The next step is to consolidate the data of...

If you replace the sub-selects to regular JOINs it will certanly clearify a lot and most likely improve performance. To make the query sargeble you also need to remove the...

The "SELECT @Emp_ID = Emp_ID" part assigns a value to a variable and does not return any records. Therefor it can't be used to insert records into a (temporary) table.

You...

If they re-appear automaticly, they could be started by an SQL Agent job or perhaps by an application (like a monitoring application). You need to find out the process that...

Can you give us the exact code of the procedure and the exact code you execute from the query window, instead of a descriptive text of your action? If possible...

I don't have a script myselef, but it looks like this http://www.sqlservercentral.com/scripts/Database+Mail/100073/ can give you a rather good starting point.

You can also create a script yourself using the [msdb].[dbo].[sysmail_add_....._sp] stored...

Do you have a (local) firewall that blockes all connections?

Are you and your co-worker on the same network?

Can you connect when you use your co-workers workstation?

Can your co-worker connect when...

Have you looked at the script section of SQLServerCentral?

http://www.sqlservercentral.com/search/?q=mail&t=s&sort=relevance

sestell1 (6/24/2014)

---

You can save your custom colors with specific connections if you use 'registered' servers in SSMS.

I like to set all my production server connections to red, to cut down...

Abhijit More (6/23/2014)

---

As per my understanding SQL should compare the value one by one if that it the case it should have consider the matching value. Can you please explain...

Abhijit More (6/23/2014)

---

As per my understanding SQL should compare the value one by one if that it the case it should have consider the matching value. Can you please explain...

Your problem is the text "HANDLING CHARGE" a complete value of its own, but also exists as a part in every other value. You need to alter the JOIN to...