Description: This procedure will allow you to find any string in any DB Object with its name or part of its name.

It will also allow you to find the column...

This has been a huge pet peave of mine for a long time. Brilliant people who can't even talk to (or get along with) a fence post. Add to this...

Wow, you made my day...that's exactly what it was! Thank you very, very much! Someone created an alias on our Dev SQL server so that whenever we reference the Prod...

Thanks for your reply. I have been in a class most of the day.

I didn't find anything unusual in the host file. The server I am trying to create the...

Here's the code:

EXEC master.dbo.sp_addlinkedserver @server = N'LinkSvrName', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LinkSvrName',@useself=N'False',@locallogin=NULL,@rmtuser=N'ReportsUser',@rmtpassword='########'

GO

EXEC master.dbo.sp_serveroption @server=N'LinkSvrName', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'LinkSvrName', @optname=N'data access', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'LinkSvrName', @optname=N'dist', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'LinkSvrName', @optname=N'pub', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption...

Thanks for the tip! In Notepad++, the code (a sample of it) displayed like this:

declare @Database_Name nvarchar(100);????????????????????set @DATABASE_NAME = 'AdventureWorks2012'

declare @Rebuild_Threshold_Percent nvarchar(10);????????set @REBUILD_THRESHOLD_PERCENT = 30

declare @Reorganize_Threshold_Percent nvarchar(10);????????set @REORGANIZE_THRESHOLD_PERCENT = 30

declare...

When I try to run this script, I get the errors below. Note! These same 'Incorrect syntax near '' ' happen at times on other scripts I get from SSC...

Is there any way to get the name of the SQL module where the query resides?

Thanks - but I am not finding any information in this article related to tracking job changes, or did I miss something?

Went there, but there are no users listed in the 'Users or roles:' area.

I am sorry as I posted this question in the wrong forum. We are actually using 2008. Does 2008 require a different solution other than what is recommended above? I...

Still find Mystery Science Theatre 3000 to be hilarious whenever I can catch it. DVD's are available as well.

Call of Duty - Black Ops has been taking up a lot of my time lately.

Thanks to all for your input on this!

I actually was able to find yet one more way to get this to work!

select distinct

t1.A_PREFIX,

...

Don't know which is worse, this case, or someone who actually has the knowledge but is too lazy to put it to use...a slacker, in other words.