More information is needed to really understand what you really want...

You could go through the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for information on how to post better questions so that you get...

Is this the same procedure to which you're passing parameters @art_Filter and @sect_Filter as 'P Soni' and 'Ra tata'?

From the code it looks like @art_Filter and @sect_Filter should be SQL...

As usual - I forgot the simplest method...use the "Generate Scripts" option in management studio to generate SP scripts by specifying one file per object... :Whistling:

The system views sys.sql_modules (and sys.all_sql_modules) will have the text of the stored procedure in the "definition" column...

An easy way to get text out of these tables is

DECLARE

If you are looking for columns that are not used by your application - and assuming that your application uses stored procedures/functions/views to access data - you can parse through...

I don't have anything that tops the "not like %[0-9]%" 🙂

I only said it might not be the most elegant since someone else might come up with a more...

Couple of thoughts:

Is tempdb configured properly on the new server (i.e. on its own drive, 1 tempdb file per processor is recommended - this might vary, is it sized...

More elegant (actually lesser lines of code - not the most elegant) would be:

select usercode as [User#], UserName [User Name], Email from DTBL_Users where UserName not like '%[0-9]%'

From an older post on this forum - the suggestion there was to check for corruption...since you didn't mention this in the list of things you already did you might...

I'm not able to repro it in my CU2 environment (that's version 10.0.1763.0 right?)

Like Shinny mentioned - if the "Include IF NOT Exists Clause" is set to True then I...

INFORMATION_SCHEMA.ROUTINE_COLUMNS only returns data for table valued functions and not for stored procedures right?

You can use SET FMTONLY ON and then call the stored procedure to view the columns returned by the proc without executing it...remember to turn it OFF after you are...

I don't think anyone would go in for partitioning if it entailed dropping the database :)...in other words - it is very much possible to partition your tables without dropping...

You can use the datepart function to get the hour and minute information...using other styles in the convert (120 for example) will not work as the format is hh:mi and...

Is this what you are looking for? You might want to tweak the code if it doesn't perform well for large amounts of data...

--setup data

DECLARE @Tab1 TABLE(field1 int, field2 int)

INSERT...