Implications Of Using Sp_dropserver?
Jun 22, 2005I need to rename my server and i believe i have to use dropserver and addserver. What are the implications of using these commands. Will I lose any data or anything?
Thanks
Nick
I need to rename my server and i believe i have to use dropserver and addserver. What are the implications of using these commands. Will I lose any data or anything?
Thanks
Nick
Trying to clean up after installing several SQL servers on a server. Started by installing SQL2000 enterprise as a named instance. Then added a instalation of SQL2005 enterprise again as a named instance. Then renamed OS level Server / Computer name. Now want to rename the SQL Servers or drop and then re add.
Anyway a long story short I have searched many boards and tired a bunch of things but still I come back to How can I remove things that show up in the list when you use the osql /L command from a command prompt.
Here are several things I have either tried or checked with many different varaitions:
SELECT @@SERVERNAME
SELECT SERVERPROPERTY ('MachineName'), SERVERPROPERTY ('InstanceName')
sp_helpserver
go
sp_dropserver 'MachineNameInstanceName'
GO
sp_addserver 'MachineNameInstanceName', local
GO
DECLARE @srv sysname
SET @srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @srv
If this is a target server (you have jobs sent from a master server), you have to exclude them, so you don't convert those jobs into local jobs:
WHERE originating_server = '<old_name>'
After I created the following SET statement in my cube it appears as if SSAS is always calculating it before I can switch to the browser view in BIDS. So it almost becomes a performance issue. Also I cannot see it from Excel, why would that be?
Code Snippet
CREATE SET CURRENTCUBE.[Top10Count]
AS TopCount(
CROSSJOIN(
{[DIM IMPORTMONTH].[REVIEWPERIOD].DefaultMember},
{[DIM DMDUNIT].[DMDUNIT].Children},
{[DIM DMDGROUP].[DMDGROUP].Children},
{[DIM LOC].[LOC].Children}
)
,10,[Measures].[QTY]) ;
Here is my questions, it would be great if somebody could advice me:
Why can't I see the SET within Excel although I have marked it visible and given it a name? I see other SETs.
In order to not see empty combinations I would like to add the nonempty() function but cannot get it to work. Where would I put it?
If a user wanted to see the Top10 rows based on QTY I'd expect her/him to pick the SET above and the required dimensions along with the QTY measure and the list should come up, is that correct?
My customers use Excel as the front end so I nees a solution that supports that.
Thanks for any help in advance.
Regards,
Dirk
When our servers were built the regional settings were left as US even though we are in the UK.
SQL 2000 was then installed using the defaults and so the codepage is set to
SQL_Latin1_General_Cp1_CI_AS
Not realising that the locale being used in the company was US I built another server and set the default locale to UK and then installed SQL server 2000 which resulted in SQL having a different collation.
When I resotred some databases to my new server there were problems with some of the views and it was traced back to the collation settings.
Looking forward, should the company resolve the fact that we have an incorrect collation on our SQL servers? The implication of this is that all SQL servers will have to be built with US regional settings - otherwise our databases will not function.
Is there a compelling reason why we should resolve this - or just stick with it? What are the implications of sticking or changing?
I'm working with a temporal database of inventory which is updated daily. It looks something like this: TableID ProductID InventoryValue DateAdded DateExpired
The DateAdded field is placed when the row is inserted & each time new information is evaluated, it is considered against this row. DateExpired is finally set when a new row comes to replace it with a change in information. That part works.The part that doesn't work is that often, my distributors will omit inventory as a way of specifying a 0 quantity value. So If I had 100 rows & now I have 95, this means that 5 are now out of stock. Considering the way that my db is set up, it's difficult to identify whether no change was made or if I did not receive the inventory value. How would you set it up such that this is a consideration?
Hi, I'm trying assess the impact of supporting UTF8 character sets on our Internet portal. What are the dos and donts of "internationalizing" our website in storing user data for user account type of information (e.g. username, password, address, etc.)?
Thanks!
D
I choose SQL and windows authetication during SQL Express 2005 install. Will this has any impact on the connection string in my Visual Studio 2005 environment?
View 3 Replies View RelatedHi,
I am replicating a couple of SQL2K databases via transactional rep and remote 2K distributor to 1 SQL2K5 database.
I want the distributor to email me when/if any of the agents fail etc. In order to set this up, I think that I need the SQL Server service to use a domain account (from error messages that I have been getting). It is currently using a local system account (it was a test box in a previous life).
I have tried this briefly, and found that it lost the publisher details in the replication monitor. Can anyone tell me what the implications for changing the SQL server service user and password are? Am I going to have to tear down and rebuild replication? The SQL Server Agent is fine - I am trying to get the two services in sync.
Hello Everyone,
Does anyone know if there are any licence implications (SAP side) against Microsoft .NET Data Provider for mySAP Business Suite?
I heard from a colleague that if my SQL Server has (for example) 5 users, if SQL does connect to SAP, it would require the user license of 5 more users?
If there any implications similar to this one with SAP?
Regards,
Joseph