Try the Microsoft Assessment and Planning toolkit:

http://technet.microsoft.com/en-us/library/bb977556.aspx

SQL Agent must be started when you use scheduled jobs and/or alerts. In most systems SQL Agent is started.

Below are two solutions.

The first solution returns all columns from both [ld_table] and [ls_table] with the minimum values from [ls_tabe]. The rows include the ones from [ld_table] without a matching...

It would be helpfull if you can provide some sample data.

From your description it looks like the [ls_table] has duplicate values of [ld_id]. When joining both tables, these duplicate values...

And like I said before: only ONE value of this multi-row query wil be stored...

Because you assign the updated values from a table to a single variable, it will still be possible to get the wrong results. The update on the table could result...

The problem is you can't assign multiple values to a single variable. So your "select @mystring=...." statement will only return the last updated value. You also has the order of...

If I apply the "Danish_Norwegian_CS_AS" collation to the query it does indeed sort BB-CC-AA. So yes, the collation does matter.

I don't know why, but perhaps that's because I'm not Danish...

I've read more documentation and I stand corrected. You are absolutely right! Sorry for the misleading...

Andreas Wolter-332291 (8/28/2013)

again:

"the port has to be unique. But you should be able to just connect via Network Name, and have the SQL Server Browser Service have the port resolved...

What is the collation you use for your instance?

In what order do you want your results?

Your stored procedure should be working fine. The code below is working on my system.

use AdventureWorks2008R2;

go

create PROC [dbo].[sp_getrecords]

(

@TableName varchar(4000)

)

AS

begin

exec('select * from '+@TableName+'')

end;

go

exec [sp_getrecords] 'DatabaseLog';

exec...

Start "services.msc" on the host server and check if all needed SQL services are started.

- SQL Server

- SQL Server Agent Can not be started with SQL Express

- SQL Server Browser

Start...

According to your business rules: what value does IPN.IPN_CHG_DT need to be in the temp table?

The values are taken from the SELECT statement (and not generated on-the-spot), so the actual...

Please, can you clarify what you are trying to accomplish? Where is the data to fill the temp-table coming from? How (on what columns) do you want to join the...