Sounds all to familar, especially with people not locking their workstations. At a previous employer we had a security audit for anyone working on sensitive high level information and...

You have index(s) with a - in their name. If the script does not put the index name in [] brackets when rebuilding/reorganising, then the script will fail.

Either change...

Jason-299789 (1/2/2013)

---

so is @p_error an integer?

In which case you will need to change the

IF @p_Error IS NOT NULL

SET @sql = @sql + 'AND RS.ERROR_CODE = '...

Either change the error code variable to a varchar or convert the variable when appending it to the string using cast or convert.

SET @sql = @sql + 'AND RS.ERROR_CODE =...

My first guess would be with all the implicit conversions it has to do converting the strings '10/1/2012' and '11-30-2012' to datetime.

Can you upload the execution plans in a SQLPLAN...

DECLARE @Expiry_Date DATETIME = '2012-12-25 00:00:01.003', @Prod VARCHAR(MAX), @Product_Name VARCHAR(10) = 'Vehicles'

SET @Prod=@Product_name + RTRIM(@Product_name)

+ ' (Expires '+RTRIM(DATENAME(MM, @Expiry_Date ) + RIGHT(CONVERT(VARCHAR(12), @Expiry_Date ,107),9))+ ')'

SELECT @Prod

Output is

VehiclesVehicles (Expires December 25,...

DECLARE @Expiry_Date DATETIME = '2012-12-25 00:00:01.003'

SELECT '(Expires '+RTRIM(DATENAME(MM, @Expiry_Date ) + RIGHT(CONVERT(VARCHAR(12), @Expiry_Date ,107),9))+ ')'

Gives me an output of

(Expires December 25, 2012)

Why do you want to copy them?

What is the reasoning behind your task?

Well something is wrong as I run it I get the , in the output between the date and year which is what the convert 107 does.

What is the data...

then do what you where doing in the first place, this is how it outputs

SELECT '(Expires '+RTRIM(DATENAME(MM, GETDATE() ) + RIGHT(CONVERT(VARCHAR(12), GETDATE() ,107),9))+ ')'

(Expires December 19, 2012)

Please post code, data and expected outcome as per the second link in my signature.

Sample data would be good as well

Using the following sample data

insert into Indexing values (199),(200),(210),(220),(230),(240),(250),(251)

insert into Indexing2 (Col4) values (199),(200),(210),(220),(230),(240),(250),(251)

I get no duplicates and now stream aggregate, the only difference...

Configure it by changing Group Policy, ask your AD guys to put all your SQL servers into an OU then assign a GPO to that OU so that accounts can...

Backup all databases, script out all server wide objects, uninstall, reinstall, run all server with objects back in, restore all databases bar master

Or

Install a standard named instance, transfer everything to...

I would direct you here, someone is asking the same question

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

Its all down to the XML name space in the well formed XML