Have you checked if you have more than one instance of SQL installed? Also, are both IP's on the same server or different ones?

Not sure if product codes would be unique for same product installs on different servers... although reading a value from registry sounds interesting as well...

If you assume that you will not have 2 SQL server instances with the same servername, you could maybe use either the checksum or hasbytes function applied to the servername...

Did you recently change the actual servername (on the server, Windows)?

How did you come up trying to connect with the -be extension?

I was going to mention something similar. Messages above 50,000 are custom messages added to sys.messages manually (via the sp_addmessage)

There must be some custom process running that gives that message.

...and besides that you can also implement DDL Audit solutions.

See here and here for references

I have seen this implemented as Triggers at DB level and saving...

Besides a script, you can use the excellent SQL Search Tool from RedGate (It's Free 🙂 )

Other than that, you can use this simple query:

SELECT

ROUTINE_NAME,

ROUTINE_DEFINITION

FROM...

You might want to give this article a read.

Ali,

If I run this for example on a table that has a LOB:

ALTER INDEX [TheIndexName] ON [PROD].dbo.[TheTableName]

REBUILD WITH (SORT_IN_TEMPDB = ON,ONLINE = ON)

In this case TheIndexName...

Alli,

the script you mention should be erroring out on those tables that have LOB. We use a similar script and those tables are just "ignored" on our ONLINE...

If it is an 24x7 operation and there are LOB's, you are out of look doing them online. You will need to schedule downtime to reorganize/reindex those tables.

As other mention above, the connectivity to the new IP address is your biggest worry, and this of course includes the DNS records if not in an AD for internal...

And once again, another flawed simple question is busted by lack of attention on how the question is formulated:

a) No SQL version supplied

b) No indication whether it is an unaltered...

..... and in...

Matt, I see what you mean now.... it is related to the SSRS Instance, not the SQL instance what you are talking about. My bad..... I guess it would require...