This gets the results that you want.

DECLARE @Name varchar(100),

@Number int,

@ClassName varchar(100),

@ErrorMessage varchar(2000)

...

Check to make sure you have a mail profile enabled in the Alert System properties of SQL agent.

Right-click on SQL Server Agent in SSMS, choose properties, then go to the...

Unfortunately it wont work.

http://www.sqlservercentral.com/Forums/Topic1079134-391-1.aspx

Take the * out of you column list. like so:

SELECT IPTU.DimImovel.DimGeograficaID,

Pub.DimGeografica.Geo_CL,

Pub.DimGeografica.Geo_Logradouro,

Pub.DimGeografica.Geo_Bairro,

Pub.DimGeografica.Geo_AreaPlanejamento,

Pub.DimGeografica.Geo_RegiaoAdmin,

Sum (IPTU.FatoLancamentoIPTU.Val_IPTU) AS [val iptu]

FROM Pub.DimGeografica

INNER JOIN IPTU.DimImovel

ON Pub.DimGeografica.DimGeograficaID =

IPTU.DimImovel.DimGeograficaID

INNER JOIN IPTU.FatoLancamentoIPTU

ON IPTU.DimImovel.InscricaoImobiliaria =

IPTU.FatoLancamentoIPTU.InscricaoImobiliaria

GROUP BY IPTU.DimImovel.DimGeograficaID,

Pub.DimGeografica.Geo_CL,

Pub.DimGeografica.Geo_Logradouro,

Pub.DimGeografica.Geo_Bairro,

Pub.DimGeografica.Geo_AreaPlanejamento,

Pub.DimGeografica.Geo_RegiaoAdmin

SELECT @@VERSION

This will tell you if instance in on hypervisor.

Have a look at the sys.sql_modules(http://msdn.microsoft.com/en-us/library/ms175081.aspx) system view. The definition column should have the data you are looking for.

Thanks Colleen. I had thought of this and double checked my setup for kerberos which looks ok. If kerberos was not setup properly the linked server would not work with...

using "Database Engine Query", either from the button in tool bar or the file menu, will cause the prompt when subsequently opening .sql files. This will only persist for the...

I do not know if this will work for you but if you change the datatype of your text_value column in the query to non unicode the correct values are...

If you use Style 1 when converting from a character string to a binary value, the input character string should include the 0x prefix; if you use Style 2, it...

Check the compatibility level of the database. It worked fine for me until i changed the compatibility level of the database that the function was installed in to sql2000.

Your set up must be completely different from mine. The shortcut keys for File -> Open -> File are Ctrl-Shift-Insert (not Ctrl-O) on my version of SSMS. And it does...

not certain but possibly cross apply (http://msdn.microsoft.com/en-us/library/ms175156.aspx) might work.

something like this

INSERT INTO [ToolKit_Prod].[dbo].[MedicalLicense]

([ProviderID]

...

Did you check you created databases for any user created objects? even if you did not create any objects manually there may be some in model and thus also in...

For me it does work that...