Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

Changing SQL Server IP address effects

Hi All
Will changing SQL Server IP address affect/break anything in sql server?
Thank you in advance.
from the server point it won't break anything.
clients using TCP/IP connection won't be able to connect 'til updated with
server new IP address
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:120646C1-6CDD-4909-809B-772E1C989B38@.microsoft.com...
> Hi All
> Will changing SQL Server IP address affect/break anything in sql server?
> Thank you in advance.
>

changing servers and ip affect sql dbs?

Hello:
I make an environmet server and all sql server applications ,
it works know fine, but I need to change the server of place to
production department and it will have another ip does this change affect all the information I backup in sql ?
Thanks.It shouldn't affect anything unless you are actually connecting to the server with the ip address. As long as it is assigned the same servername it should work fine.|||Originally posted by Memnoch1207
It shouldn't affect anything unless you are actually connecting to the server with the ip address. As long as it is assigned the same servername it should work fine.

tomorrow will be the big day..thanks and regards.Mirtha.

changing RDL of a snapshot?

As I understand it, once you snapshot a report, any changes to the RDL of the
report will not affect the snapshot. Let's say (using a purely hypothetical
situation ;-) that I misspelled the text of a column header. Has anyone
looked into messing with the stuff in the ChunkData table to go change a
piece of text in the RDL of the snapshotted report? Obviously this would be a
completely unsupported action as far as Microsoft is concerned... and I would
obviously proceed at my own risk.
Can anyone give me any hints about what format the ChunkData.Content column
is in so that I could read and modify a few bytes?You are right - this is an unsupported action.
BTW: you won't find *any* RDL XML in snapshots. Snapshots are output-format
independent, already processed reports. The risk is extremely high to get it
wrong when messing with them (in particular for compressed snapshots on
SP1). If you get it wrong, the snapshot is no longer usable and will result
in a fatal error "unexpected error during processing".
Keep in mind that you are on your own once you modify anything directly in
the report server databases.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"FurmanGG" <FurmanGG@.discussions.microsoft.com> wrote in message
news:BFBF8E3A-054F-473A-829B-5AB1798CCA04@.microsoft.com...
> As I understand it, once you snapshot a report, any changes to the RDL of
the
> report will not affect the snapshot. Let's say (using a purely
hypothetical
> situation ;-) that I misspelled the text of a column header. Has anyone
> looked into messing with the stuff in the ChunkData table to go change a
> piece of text in the RDL of the snapshotted report? Obviously this would
be a
> completely unsupported action as far as Microsoft is concerned... and I
would
> obviously proceed at my own risk.
> Can anyone give me any hints about what format the ChunkData.Content
column
> is in so that I could read and modify a few bytes?

Changing queries for SQL Server 2000

I am currently using ASP as the front end and SQL Server 7.0 as backend. We are migrating SQL Server 7.0 to SQL Server 2000. How this will affect my queries used in the fron-end. Also as for as T-SQL is concerned what are all the changes happened in SQL Server 2000 (which is not there in SQL Server 7.0)?I think 2000 is pretty good backwards compatible with SQL 7.0 scripts, check out these pages for features in SQL 2K.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_00_1lbn.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/CoolestFeatures.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part1/c0261.asp

HTH