try to copy and paste into word first and then paste it to notepad to see if the off characters are removed then copy it to management studio.

A sample if you need it

--SQL2008++

DECLARE @i INT = 5,

@k INT = 6

GO

--SQL2005++

DECLARE @i INT,

@k INT

SELECT @i...

sql 2005 does not allow assigning values to a variable during declaration. You can have the declare done first and then assign the values to the declared variables.

I have not...

There may be are pieces useful that works also in SQL 2005, I put bunch of counters from all over the place together to see all of them in one...

I don't know sybase

Actually remove code "SELECT

???? @SQLServerCPU = SQLServerCPU,

???? @ServerCPU = ServerCPU

FROM Util.dbo.GetCPUUsage(1)", it's redundant. See below.

[font="Courier New"]USE [master]

GO

IF OBJECT_ID('dbo.sp_SysMon') IS NULL

EXEC('CREATE PROCEDURE dbo.sp_SysMon AS SELECT 1...

Sorry, my original version uses many functions in my Util database, I thought replaced them all with the source code version. GetCPUUsage is an inline table valued function and needs...

I use redgate sql prompt too. I also check every version of apexsql refactor (free), they have many options but I still cannot get it format the way I want...

I prefer the below code not to change when I format

-- OBJECT transview HAS NOT BEEN LOCATED. DOING A GENERAL SEARCH

GO

ALTER PROCEDURE Template.[DataFolder-TransformTransActionTransViewIns]

@CntyCdList VARCHAR(MAX)

AS

SET NOCOUNT...

It gets complicated, I guess more options will be necessary. In my case I do not want the full insert statement that has 100+ columns followed by comma space but...

I like the tool a lot. I was looking for a tool to batch format sql scripts for the longest. I would like to drop some feedback after playing with...

If you want to find out the actual statement executed at the start of the sql call stack than you can get it (up to 4000 characters) by calling DBCC...

You can always retrieve more information from system views or dmv's as below. Whatever information you will want to pull out by testing local session and whatever is available, then...

For months I had done the whole data generation from within costly triggers, when the cost became very expensive I went back to using CDC but having done all kind...

Users are granted create procedure rights on purpose and not given rights to the table on purpose (and specifically denied rights to drop table). But in their procedures they can...