The good thing about using sp_executesql is that you can pass the parameter value instead of completely building the string on the fly like this...

DECLARE @sql NVARCHAR(MAX)

DECLARE @TBL...

Try using sp_executesql and see if that fixes it.

Here is a sample that should work.

DECLARE @sql NVARCHAR(MAX)

DECLARE @TBL TABLE (i int)

SET @sql = 'SELECT TOP 10...

You need to remove the single quotes from the variable in your stored procedure.

Change this...

AND C.ContractStatus = 'A' AND S.UnitState = '@UnitState'

To this...

AND C.ContractStatus = 'A' AND S.UnitState = @UnitState

Pretty good bit of summary info. I like it. Just sent it out to the other DBAs at work.

You need to add it to the scripts section so I...

Here is an article about index fragmentation

http://msdn.microsoft.com/en-us/library/ms189858(SQL.90).aspx

And here is the script that I am currently using to defrag/rebuild all indexes.

http://blogs.digineer.com/blogs/larar/archive/2007/07/30/smart-index-defragmentation-for-an-online-world.aspx

There are several others available as well.

As long as you output restults to text, this should work.

sp_msforeachtable 'PRINT ''Table Name: ?''; EXEC sp_helpstats ''?'''

All of the jobs are stored in the msdb system database. If you have a backup of that database on your old drive, you can restore it over your new...

The answer to both of your questions is yes. Indexes take up space. You can even create a seperate filegroup and move them if you want. With an Indexed...

That's right. I have been working with 2008 for too long. 🙂

The only thing that I can think of that would cause it may be a case sensativity issue. Try this and see if it works.

ALTER DATABASE [SGCT] SET COMPATIBILITY_LEVEL...

You can export the Maintenance Plan to a file and import it into another server. All you have to do then is open the Maintenance Plan Design Tab and...

Try something like this.

select a,b,c

from abc

where (

((len(@P1) > 0 and DocNo like @P1 + '%') or

(len(@P1) 0 and DocNo like @P1 + '%') or

(len(@P1)...

Here is some code that may help. I am using xp_cmdshell to create the file, so you may need to enable it first.

--Enable xp_cmdshell

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC...

Like Steve said, this may be better suited for the .Net forums, but just like everything. It depends. I rarely use StringBuilder when I code. I only use it when...

You could create a temp table to hold the variable and then use the value from the temp table.

Something like...

DECLARE @Tbl TABLE (NewKey varchar(100))

INSERT INTO @Tbl

EXEC SomeProc

SELECT NewKey FROM @Tbl

There...