If not as Ed says then it may be the files are still locked. Try rebooting with SQL disabled and then see if that doesn't work. Again if yours doesn't...

Always, just make sure you alter any sensitive bits.

Actually on count 4 I suggest you read this

http://www.microsoft.com/sql/evaluation/overview/default.asp

It states that it can handle 25 concurrnt users. Basically this means only 25 connections can be open at any given...

You have to stop SQL server or close the db from open state (auto close option) and keep everyone out while defrag occurrs. Personally best way is to stop SQL...

What is your goal? As far as answer when say table 1 a = 1 and table 2 a = 2 then what would be @a? If table 1 is...

ALong those lines can you post the DDL of the staging and live table. It may be as simple as the data is being suffeled in memory for inserts but...

Start here if you need restoring more than just SQL.

http://www.microsoft.com/technet/security/tips/recover.mspx

SQL However this is a good read. (it is a link on the first url listed)

http://www.microsoft.com/resources/documentation/sql/7/all/proddocs/en-us/admincmp/75517c03.mspx

As long as you followed general syntax of SQL 92 wihout using extended DDL for Postgre then it should be as simple as point to the SQL drivers. However I...

Ok I do think you are making more of it than you need to. Now that I understand what you need do this

@Some_String_Variable + (CASE

 WHEN COALESCE(@PhoneNumber, @PhoneExtn, '') =...

Note you need to change

while @i < 36

to

while @i < 37

or you will miss 9

However building on Steves here is an example to give you what you want.

set nocount...

DO

SELECT  @strString1 = @strString1 + sql_name + ', '

FROM (SELECT DISTINCT sql_name FROM #temp) A ORDER BY SQL_name

You cannot because it is not a MAPI client.

You need to look at the code of the procedure (GetRunDataset) to know why.

If you have SQL Server Client Network Utility installed on that machine check to see if the Named Pipes Library is disabled (General tab) or missing (Network Libraries tab).

Either use Triggers to audit (only selects won't work) or check you settings for the Trace.

1) Is it pointed at the right server.

2) Are there any filters

3) Make sure profiler...