Hello Franco

I still don't really understand the requirement. Cann you please post two or three sample rows from your file (sure pseudo phone numbers 😉 ) and how they shall...

Hello

A little bit more information would help. 😉

What are the "jobs" doing?

If you want to relize a UNION you can do:

[font="Courier New"]

DECLARE @old TABLE (id INT, fld1 VARCHAR(100))

DECLARE @new TABLE...

Hello Stephan

One of the main problems may become your tempdb.

If you install a SQL Server the tempdb gets the specified collation of the server. If you add any databases by...

Hi

This may solve your problem.

[font="Courier New"]

SET NOCOUNT ON

DECLARE @Search VARCHAR(128) SET @Search = 'ANSI%'

DECLARE @PrintOnly BIT SET @PrintOnly = 0

DECLARE @Tables TABLE (Name SYSNAME)

INSERT INTO @Tables

   SELECT Name

   FROM...

Hi

So you do not only need the name of the current procedure but the complete callstack to your current position.

Maybe this helps (did not evaluate):

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124537

Greets

Flo

Hi Chris

Sending a mail within a trigger seems by design to be a performance issue. Maybe it would be a better solution if you

either:

Write into a mail_to_do table which may...

Hello Dennis

Maybe you have some more information. The statement you posted is not optimizable since you give more detailed information about your WHERE clause, your network connection between the servers...

Hi Jeff

This was only a simple sample. Sorry for performance problems due lockins on the id-table 😉

In real implementation wi work with a temporary table for scripts and procedures to...

Picture of you?? Maybe we are twins!!

I'll...

Hello Jeff

No, sorry. SSIS are only part of Stadard and Enterprise and Developer Editions.

See comparsion at http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx .

If you only use the SQL Server (and all its components) only for...

Hello Jeff

It is not possible to install an Enterprise Edition on a XP operating system. You can only install an Express, Compact or Developer edition on a client OS.

The only...

Hello Stef

Here a complete example how to use a id table:

-- Event table

IF (OBJECT_ID('tempdb..#event') IS NOT NULL)

DROP TABLE #event

GO

CREATE TABLE #event (org_id INT, type_id INT, id INT)

GO

--...

Hello

This is a little to less information. Did the system configuration check report any warnings or errors?

Which components are disabled?

Which OS? Which edition of SQL Server?

Greets

Flo

Hi Stef

There are various suggestions in the other thread. What are you missing?

Greets

Flo

Hi

Another way:

DECLARE @v-2 NVARCHAR(MAX)

SELECT @v-2 = definition

FROM master.sys.all_sql_modules

WHERE object_id = OBJECT_ID('sp_adduser')

PRINT @v-2

Attention

The PRINT function is restricted to...