Hi,

But i still have one problem, i want to run that script on SS 2005 and when i try i received

"Password validation failed. The password does not meet Windows...

Hello again,

It seems perfect for me, thanks, obrigado,gracias 🙂

Hi Michael, my sp does the next...

CREATE PROCEDURE [dbo].[im_get_fn_contact_types]

@uids NVARCHAR(MAX)

AS

SET NOCOUNT ON

CREATE TABLE #tbl_registers (uid UNIQUEIDENTIFIER)

INSERT INTO #tbl_registers

SELECT data FROM dbo.Split(@uids,',')

DECLARE @query NVARCHAR(MAX)

DECLARE @query_clause NVARCHAR(MAX)

DECLARE @query2 NVARCHAR(MAX)

SET @query2 = ''

SET...

Hello,

Thanks for the quick answer...but i created the sp because i need to use temporary tables, and in functions is impossible, so my option was create the sp and then...

Hello,

Thanks for ur quick answer, works perfect... 🙂

Best Regards

Thanks Mark for u quick answer, help me a lot

Hi again,

How can i know which tables are created on tempdb and aren't used anymore, in sysobjects?

Thanks for the quick answer,

The problem is that tempdb is used all the time in production, maybe at night i could do that... thanks again

Thanks for answer,

As i can see on the link u send, no one knows how to specifies the maxium values for various numeric datatypes, i know that int is 2147483647...

Hi, thanks for answer my question,

What do you mean when u say "current" table?

Maybe i didnt explain quite well... For example, i have a table A in Production with...