I setup a production server today I thought the same as a development server
that I was working on. However, I can not see the Data-Driven Subscriptions
button to create a new data-driven subscription. My account is a system
administrator and also a content manager. On my development server I can
create a data-driven subscription. What did I miss?did you install the Standard Edition? I don't think it supports Data
Driven Subscriptions.|||That is the version that I installed. I'll have to look for the documentation
that says I can't do that then. Thanks.
"bri" wrote:
> did you install the Standard Edition? I don't think it supports Data
> Driven Subscriptions.
>|||You need Enterprise Edition to utilize Data Driven Subscriptions
"Brian" wrote:
> That is the version that I installed. I'll have to look for the documentation
> that says I can't do that then. Thanks.
> "bri" wrote:
> > did you install the Standard Edition? I don't think it supports Data
> > Driven Subscriptions.
> >
> >
Showing posts with label production. Show all posts
Showing posts with label production. Show all posts
Sunday, March 25, 2012
Tuesday, March 20, 2012
Can not change index INCLUDE fields order....
Hi...
I was in the process of synchronzing the indexes in two seperate databases;
production and development. I ran into a problem with one table.
The current production index looks like this:
CREATE NONCLUSTERED INDEX [INX_Table1] ON
[dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field3], [Field4], [Field5],
[Field6], [Field7])
The current development database index looks like this
CREATE NONCLUSTERED INDEX [INX_Table1] ON
[dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field4], [Field3], [Field5],
[Field6], [Field7])
I need the make changes on the production database so it uses the same
structure as the development database, so I delete the index on the
production database (successful).
I then execute the development index command on the production server.
What is hard to believe is I get the same structure as was there BEFORE. No
matter what I do, (including change the index name), the field
order in the "INCLUDE" portion never changes.
Has anyone seen this before? I realize that the order of the fields in the
"include" area isn't important, but the synchronization software reports
differences (which is a real PITA).
Thanks,
ForchHi
"Forch" wrote:
> Hi...
> I was in the process of synchronzing the indexes in two seperate databases;
> production and development. I ran into a problem with one table.
> The current production index looks like this:
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field3], [Field4], [Field5],
> [Field6], [Field7])
> The current development database index looks like this
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field4], [Field3], [Field5],
> [Field6], [Field7])
> I need the make changes on the production database so it uses the same
> structure as the development database, so I delete the index on the
> production database (successful).
> I then execute the development index command on the production server.
> What is hard to believe is I get the same structure as was there BEFORE. No
> matter what I do, (including change the index name), the field
> order in the "INCLUDE" portion never changes.
> Has anyone seen this before? I realize that the order of the fields in the
> "include" area isn't important, but the synchronization software reports
> differences (which is a real PITA).
> Thanks,
> Forch
>
I thought this may be that on the develop machine the column [Field3] had
been dropped and re-created at some point, although my tests on a SP2 machine
have not replicated this!
John|||Are you sure that Field3 and Field4 have the same data definition in
both databases?
Are you sure the clustered index has the same definition in both
databases?
Are you sure Field3 comes before Field4 in the table definition in both
databases?
If you have table modification (such as changing a column's definition)
you could try to reindex the clustered index and recreate the
nonclustered index.
HTH,
Gert-Jan
Forch wrote:
> Hi...
> I was in the process of synchronzing the indexes in two seperate databases;
> production and development. I ran into a problem with one table.
> The current production index looks like this:
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field3], [Field4], [Field5],
> [Field6], [Field7])
> The current development database index looks like this
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field4], [Field3], [Field5],
> [Field6], [Field7])
> I need the make changes on the production database so it uses the same
> structure as the development database, so I delete the index on the
> production database (successful).
> I then execute the development index command on the production server.
> What is hard to believe is I get the same structure as was there BEFORE. No
> matter what I do, (including change the index name), the field
> order in the "INCLUDE" portion never changes.
> Has anyone seen this before? I realize that the order of the fields in the
> "include" area isn't important, but the synchronization software reports
> differences (which is a real PITA).
> Thanks,
> Forch
I was in the process of synchronzing the indexes in two seperate databases;
production and development. I ran into a problem with one table.
The current production index looks like this:
CREATE NONCLUSTERED INDEX [INX_Table1] ON
[dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field3], [Field4], [Field5],
[Field6], [Field7])
The current development database index looks like this
CREATE NONCLUSTERED INDEX [INX_Table1] ON
[dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field4], [Field3], [Field5],
[Field6], [Field7])
I need the make changes on the production database so it uses the same
structure as the development database, so I delete the index on the
production database (successful).
I then execute the development index command on the production server.
What is hard to believe is I get the same structure as was there BEFORE. No
matter what I do, (including change the index name), the field
order in the "INCLUDE" portion never changes.
Has anyone seen this before? I realize that the order of the fields in the
"include" area isn't important, but the synchronization software reports
differences (which is a real PITA).
Thanks,
ForchHi
"Forch" wrote:
> Hi...
> I was in the process of synchronzing the indexes in two seperate databases;
> production and development. I ran into a problem with one table.
> The current production index looks like this:
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field3], [Field4], [Field5],
> [Field6], [Field7])
> The current development database index looks like this
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field4], [Field3], [Field5],
> [Field6], [Field7])
> I need the make changes on the production database so it uses the same
> structure as the development database, so I delete the index on the
> production database (successful).
> I then execute the development index command on the production server.
> What is hard to believe is I get the same structure as was there BEFORE. No
> matter what I do, (including change the index name), the field
> order in the "INCLUDE" portion never changes.
> Has anyone seen this before? I realize that the order of the fields in the
> "include" area isn't important, but the synchronization software reports
> differences (which is a real PITA).
> Thanks,
> Forch
>
I thought this may be that on the develop machine the column [Field3] had
been dropped and re-created at some point, although my tests on a SP2 machine
have not replicated this!
John|||Are you sure that Field3 and Field4 have the same data definition in
both databases?
Are you sure the clustered index has the same definition in both
databases?
Are you sure Field3 comes before Field4 in the table definition in both
databases?
If you have table modification (such as changing a column's definition)
you could try to reindex the clustered index and recreate the
nonclustered index.
HTH,
Gert-Jan
Forch wrote:
> Hi...
> I was in the process of synchronzing the indexes in two seperate databases;
> production and development. I ran into a problem with one table.
> The current production index looks like this:
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field3], [Field4], [Field5],
> [Field6], [Field7])
> The current development database index looks like this
> CREATE NONCLUSTERED INDEX [INX_Table1] ON
> [dbo].[Table1] ([Field1], [Field2]) INCLUDE ([Field4], [Field3], [Field5],
> [Field6], [Field7])
> I need the make changes on the production database so it uses the same
> structure as the development database, so I delete the index on the
> production database (successful).
> I then execute the development index command on the production server.
> What is hard to believe is I get the same structure as was there BEFORE. No
> matter what I do, (including change the index name), the field
> order in the "INCLUDE" portion never changes.
> Has anyone seen this before? I realize that the order of the fields in the
> "include" area isn't important, but the synchronization software reports
> differences (which is a real PITA).
> Thanks,
> Forch
Wednesday, March 7, 2012
Can I Use SQL Server 2005 Developer Edition For Client Tools?
My ISP has me licensed for a production SQL Server 2005 database, yet they
cannot provide me with the client tools that I need, specifically SQL Server
Management Studio and SQL Server Business Intelligence Development Studio.
If I purchase SQL Server 2005 Developer Edition will it have these two tools,
and will I be able to work with my production SQL database? Just for
clarification, I use the Business Intelligence studio to drop my existing
tables, and I migrate from locally-stored ACCESS databases to my production
SQL Server 2005 each night.On Jul 30, 3:46 pm, MIA Mark <MIAM...@.discussions.microsoft.com>
wrote:
> My ISP has me licensed for a production SQL Server 2005 database, yet they
> cannot provide me with the client tools that I need, specifically SQL Server
> Management Studio and SQL Server Business Intelligence Development Studio.
> If I purchase SQL Server 2005 Developer Edition will it have these two tools,
> and will I be able to work with my production SQL database? Just for
> clarification, I use the Business Intelligence studio to drop my existing
> tables, and I migrate from locally-stored ACCESS databases to my production
> SQL Server 2005 each night.
Yes, this should be fine. The licensing might be a bit of a gray area
though; but, I think that the ISP license should cover the production
deployment.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Regards,
Enrique Martinez
Sr. Software Consultant
cannot provide me with the client tools that I need, specifically SQL Server
Management Studio and SQL Server Business Intelligence Development Studio.
If I purchase SQL Server 2005 Developer Edition will it have these two tools,
and will I be able to work with my production SQL database? Just for
clarification, I use the Business Intelligence studio to drop my existing
tables, and I migrate from locally-stored ACCESS databases to my production
SQL Server 2005 each night.On Jul 30, 3:46 pm, MIA Mark <MIAM...@.discussions.microsoft.com>
wrote:
> My ISP has me licensed for a production SQL Server 2005 database, yet they
> cannot provide me with the client tools that I need, specifically SQL Server
> Management Studio and SQL Server Business Intelligence Development Studio.
> If I purchase SQL Server 2005 Developer Edition will it have these two tools,
> and will I be able to work with my production SQL database? Just for
> clarification, I use the Business Intelligence studio to drop my existing
> tables, and I migrate from locally-stored ACCESS databases to my production
> SQL Server 2005 each night.
Yes, this should be fine. The licensing might be a bit of a gray area
though; but, I think that the ISP license should cover the production
deployment.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Regards,
Enrique Martinez
Sr. Software Consultant
Can I use SQL Express database inside full blown SQL 2005?
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
|||It does not work saying "The user instance login flag is not supported on this version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message news:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
|||You will have to take the User Instance flag out of your connections strings, attach the database to the production system and then establish users and permissions in the production system.
There's some discussion of converting to User Instance to normal connections here:
http://msdn.microsoft.com/sql/expres...xpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:ucH0y7SHGHA.3916@.TK2MSFTNGP10.phx.gbl...
It does not work saying "The user instance login flag is not supported on this version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message news:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
|||It does not work saying "The user instance login flag is not supported on this version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message news:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
|||You will have to take the User Instance flag out of your connections strings, attach the database to the production system and then establish users and permissions in the production system.
There's some discussion of converting to User Instance to normal connections here:
http://msdn.microsoft.com/sql/expres...xpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:ucH0y7SHGHA.3916@.TK2MSFTNGP10.phx.gbl...
It does not work saying "The user instance login flag is not supported on this version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message news:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue because your production system will have different logins than your SQL Express instance.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP10.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application, can I just deploy this to production (where SQL 2005) is running and it'll still work?
Can I use SQL Express database inside full blown SQL 2005?
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||You will have to take the User Instance flag out of your connections strings
, attach the database to the production system and then establish users and
permissions in the production system.
There's some discussion of converting to User Instance to normal connections
here:
http://msdn.microsoft.com/sql/expre...expuserinst.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:ucH0y7SHGHA.3916@.TK2MSFTNGP1
0.phx.gbl...
It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?|||You will have to take the User Instance flag out of your connections strings
, attach the database to the production system and then establish users and
permissions in the production system.
There's some discussion of converting to User Instance to normal connections
here:
http://msdn.microsoft.com/sql/expre...expuserinst.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:ucH0y7SHGHA.3916@.TK2MSFTNGP1
0.phx.gbl...
It does not work saying "The user instance login flag is not supported on th
is version of SQL Server'
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message new
s:eYNBXlSHGHA.3056@.TK2MSFTNGP09.phx.gbl...
Probably. You may have to deal with some user mapping and permissions issue
because your production system will have different logins than your SQL Exp
ress instance.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"GS" <nospam@.nowhere.com> wrote in message news:uLSg2nQHGHA.2948@.TK2MSFTNGP1
0.phx.gbl...
Hi,
I have SQLExpress database under App_Data folder of my ASP.NET application,
can I just deploy this to production (where SQL 2005) is running and it'll s
till work?
Friday, February 24, 2012
Can I turn browser service off with multiple nics / Ips?
All,
We’d like to turn the unused services off on our production machine. Can we
turn the sql browser service off under the following conditions:
-No named instances
-There are 2 nics that sql server needs to listen on (different IP
addresses, both port 1433)
-The production database is mirrored.
Thanks in advance.
Hi
I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
you can easily switch it back on if you do have problems!
John
"sqlboy2000" wrote:
> All,
> We’d like to turn the unused services off on our production machine. Can we
> turn the sql browser service off under the following conditions:
> -No named instances
> -There are 2 nics that sql server needs to listen on (different IP
> addresses, both port 1433)
> -The production database is mirrored.
> Thanks in advance.
>
|||Thanks, it works great.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
> you can easily switch it back on if you do have problems!
> John
> "sqlboy2000" wrote:
We’d like to turn the unused services off on our production machine. Can we
turn the sql browser service off under the following conditions:
-No named instances
-There are 2 nics that sql server needs to listen on (different IP
addresses, both port 1433)
-The production database is mirrored.
Thanks in advance.
Hi
I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
you can easily switch it back on if you do have problems!
John
"sqlboy2000" wrote:
> All,
> We’d like to turn the unused services off on our production machine. Can we
> turn the sql browser service off under the following conditions:
> -No named instances
> -There are 2 nics that sql server needs to listen on (different IP
> addresses, both port 1433)
> -The production database is mirrored.
> Thanks in advance.
>
|||Thanks, it works great.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
> you can easily switch it back on if you do have problems!
> John
> "sqlboy2000" wrote:
Can I turn browser service off with multiple nics / Ips?
All,
We’d like to turn the unused services off on our production machine. Can w
e
turn the sql browser service off under the following conditions:
- No named instances
- There are 2 nics that sql server needs to listen on (different IP
addresses, both port 1433)
- The production database is mirrored.
Thanks in advance.Hi
I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
you can easily switch it back on if you do have problems!
John
"sqlboy2000" wrote:
> All,
> We’d like to turn the unused services off on our production machine. Can
we
> turn the sql browser service off under the following conditions:
> - No named instances
> - There are 2 nics that sql server needs to listen on (different IP
> addresses, both port 1433)
> - The production database is mirrored.
> Thanks in advance.
>|||Thanks, it works great.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
> you can easily switch it back on if you do have problems!
> John
> "sqlboy2000" wrote:
>
We’d like to turn the unused services off on our production machine. Can w
e
turn the sql browser service off under the following conditions:
- No named instances
- There are 2 nics that sql server needs to listen on (different IP
addresses, both port 1433)
- The production database is mirrored.
Thanks in advance.Hi
I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
you can easily switch it back on if you do have problems!
John
"sqlboy2000" wrote:
> All,
> We’d like to turn the unused services off on our production machine. Can
we
> turn the sql browser service off under the following conditions:
> - No named instances
> - There are 2 nics that sql server needs to listen on (different IP
> addresses, both port 1433)
> - The production database is mirrored.
> Thanks in advance.
>|||Thanks, it works great.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
> you can easily switch it back on if you do have problems!
> John
> "sqlboy2000" wrote:
>
Thursday, February 16, 2012
can i run alter "database rename logical file" on live production server?
Just wondering if i can do this on a live database?
Matt
Hi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>
Matt
Hi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>
can i run alter "database rename logical file" on live production server?
Just wondering if i can do this on a live database?
MattHi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>
MattHi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>
can i run alter "database rename logical file" on live production server?
Just wondering if i can do this on a live database?
MattHi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>
MattHi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>
Subscribe to:
Posts (Atom)