Multiple Database And Central Libraries

Jan 5, 2005

I have a question about MS sql 2000 and hope someone can give me a hand though this may not be the most suitable place to post.





I have created multiple databases storing multi-country data. Tables and store proc in each db are exactly the same except they are placed and run in different dbs in runtime.





My question is:


Is it possible to centralize all the store proc and function into a central db (or a dummy db) for easy maintenance but it allows us to point to the desired database environment in runtime even I run the store proc in central database.





I find the "Use database" command but it does allow us to use it in store proc. Any advice or suggestions???





Thanks in advance


bryan

View 4 Replies


ADVERTISEMENT

Replication :: Replicate Multiple Databases (publications) To One Central Subscriber?

Sep 2, 2015

We need to replicate multiple databases (publications) to one central subscriber. The schema of those articles are identical in all publications and also the primary keys in publications do not have any overlap.

Is this possible?If yes is there any specific thing that I should consider for it's implementation? Should each publication has it's own dedicated distributor or all of them can share one distributor?

View 2 Replies View Related

Central Database

Nov 1, 2007

Hi I would like to use SQL Express as a central database in a project but I have few things in my mind needs to be answered.

I need to create a parts table and when a user opens a part in the client application no other user should be able to modify that part info. Is this taken care by database or should I use a flag in the parts table which indicates particular part is opened and in use?

If a row (a part) in part table is read by a client how this effects the other related tables? For instance if I open part1 info in my client application and also accessed to part1 properties in another table, how can I prevent other clients to make modification in related tables related rows?


What is the best way for submiting an image for a part in part table? I dont want to store images in the database. Do I need some file transfer code which takes care of transferring image and returns the path to the database?

Thanks

View 7 Replies View Related

Updating Central Database Over The Internet

Jul 21, 2006

Hi, I've spend quite a bit of time on this but no luck. so any help is really appreciated.

I'm writing a class library dll that would pull data from a central db to offsite comps, manipulated then updated it back to the central db, much like systems salemen would use. Please keep in mind that i'm talk about LARGE amount of data. I want downloaded data to be manipulated on the client computer(without direction connection to db server) with EXCEL or something of the likes then upload changes back to the central DB.

Is there anything in SQL Integration Services that would help me? please keep in mind that data are distributed to computers over the internet, not on the same LAN. Please be as specific as possible

i'd really appreciate any help you guys can provide, thanks.

Vu,

View 4 Replies View Related

SQL Network Libraries

May 9, 2007

as far as i know, i can use these types of network libraries:




•
dbnmpntw - Win32 Named Pipes

•
dbmssocn - Win32 Winsock TCP/IP

•
dbmsspxn - Win32 SPX/IPX

•
dbmsvinn - Win32 Banyan Vines

•
dbmsrpcn - Win32 Multi-Protocol (Windows RPC)
may be someone knows, where i could find comparision and details of each one, when witch to use?

View 1 Replies View Related

Network Libraries

May 15, 2002

I have problems using SQL Profiler from a Windows2000 client PC to an SQL 7 server which is on a Windows NT machine. I can use profiler o.k. from an NT client (using Named Pipes), but can't seem to get it to work on my Windows2000 PC.
I tried changing the Default Network Library on my PC to use TCP/IP, but it still does not work. The server has a default of Named Pipes.
Can I get the server to use either Named Pipes or TCP/IP depending on whether the client communicating is an NT or Windows2000 PC?
Or is this not the problem? Is there a problem with Windows2000 and Named Pipes?

View 5 Replies View Related

C# Algorithm/ Libraries

Jan 10, 2006

Hi.

Does anyone know of or where I can find implementation of these C#  algorithm /class libraries:

a) RLS - Recursive Least Square algorithm?

b) MWAR - Multi-resolution Wavelet Auto-regresive algorithm?

c) AR - Autoregresive moving awerage algorithm?

d) EWMA - Exponentially Weighted Moving Average

The .NET framework System.Math class do not seem to have these libraries. 

Regards

   Shorin

View 2 Replies View Related

Backup Libraries - Best Practices

May 5, 2005

We are preparing to stand up a server with an HP tape library backup system using Data Protector software.

Our intention is to copy backup files from each of our db servers to the file system of the server with the tape library. There will be two tape rotation schemes where there will be a daily offsite tape and one with a monthly offsite rotation for less critical applications. Our systems group isn't happy about that configuration but are willing to implement what we want.

My questions are:
Is there any one out there using one of these and if so can you give me a 10,000 foot view of your process?

Addtionally, is this the best way to utilize this resource?

Any serious suggestions and comments are greatly welcomed and appreciated.

Sidney Ives
Database Administrator
Sentara Healthcare.

View 1 Replies View Related

Reporting Services :: Could Not Load File Or Assembly Error On Adding Custom Libraries In SSRS Reports

Sep 21, 2015

I have created a custom library(CodeLibrary) which internally references the dlls Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client.

I added this custom Dll codelibrary.dll to my SSRS report. and the expression of one of the field as 

=codelibrary.codefunction.GetValue(1000)  
codefunction is the class and GetValue is the method.

When I preview the report, I get the error "Error while loading code module:

'CodeLibrary,Version=1.0.0.0,Culture=neutral,PublicKeyToken=null'. Could not load file or assembly 'CodeLibrary,Version1.0.0.0, Culture=neutral,PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."

I am using VS2013, I have placed the custom library DLL in the path

C:Program FilesMicrosoft Visual Studio 12.0Common7IDEPrivateAssemblies

I have tested the custom library with a WPF application and it works fine.

I am not able to figure out what is causing this error.

View 4 Replies View Related

[SQL] Central European Encoding

Mar 5, 2008

Hello,I faced a problem while reading some strings from the database (SQL 2005). Some letters are encoded with html codes making the sorting really difficult. I tried to use IComparer objects with different CultureInfo information, but it doesn't do any good.I am quite new to the web development, so I don't really have any clue if there is a recommended and clean way of solving this problem. It could be that it's something really simple, but I only came up with an idea of search and replace in all strings. If possible, I would like to omit this. :) If not, please let me know.Thanks in advance. 

View 1 Replies View Related

SSIS Central Server?

Sep 20, 2007

We have about 150 SQL servers and basically we're considering the pros and cons of installing SSIS on a central SSIS server - that is responsible for all DTS jobs - as opposed to installing SSIS on the local SQL instance.



On the plus side so far:



1./ Central administration, alerting, change management etc

2./ Possible performance gain on the local instance not having SSIS installed?



On the negative side:



1./ Central point of failure

2./ Possibility that it would need to be a clustered...

3./ Compatibility issues may mean having to make the central SSIS server 32-bit?

4./ Possible performance cost of remote SSIS?

5./ With multiple DTS packages running at different times, when would we take the server down for maintenace...?

Would appreciate your thoughts.

View 7 Replies View Related

Central Store Of SQL Server Registration

Nov 7, 2000

I am attempting to centrally register all of my sql server so I can go to any workstation and open enterprise manager and select to read the sql server registration from the remote server.

I followed all of the steps in books on line about going to the central server, turning off the store/user independent option, registering all of the servers and then going to a workstation and selecting the option to read from the central server.

I get error messages like registry read error: 5 and registry read error: 2

This is getting frustrating because we have a lot of servers in our environment and re-registering them everytime is getting to be quite a pain. If the central store will not work, is there a way to write a script to register all servers in an enterprise.

Thanks,

PJ

View 2 Replies View Related

Problem With Central Subscriber Model

Apr 26, 2007

Hi,



I am trying to acheive the central subscriber model for Sql server 2005 replication. I have two publishers and the centrol subscriber. Both publishers are Sql server 2005 Workgroup edition. The following table shows the Software I have used for the test.









SQL version

Service pack

HotFix


Publishers

SQL Server 2005 Workgroup edition

2

1


Subscriber

SQL Server 2005 Enterprise edition

2

1

I have encountered an obstacle in the replication process to achieve the Central subscriber model. I have configuration table, It exists on servers TB1 and TB2 and want to amalgamate the data to a central subscriber. There are two duplicate primary key and overlapping values existing across the 2 publisher tables. These records need to be updated during the process of replication.

TB1

Guid Name CreatDate EditDate
34a.. TEST02F 3/6/2007 3/6/2007
775.. EP109F 1/29/2007 1/29/2007
ffe.. EP109G 1/26/2007 1/26/2007

TB2
Guid Name CreatDate EditDate
d008.. MS060F 7/20/2005 11/21/2006
775.. EP109F 1/29/2007 1/29/2007
ffe.. EP109G 1/26/2007 1/26/2007

Normally, the default Article properties settings are used 'DROP existing table and re-create it', however here we don't want this setting, because the one table records will then be removed, leaving just the data from the other table. So, we modify the article properties on the snapshot tab to 'Keep the existing table unchanged'€™. As result we got the PK violation error.

I have tried using -SkipError option in distribution job Replication Agent Profiles, that did not work.



Thank you for your help





View 2 Replies View Related

Central Store For Server Registration Information

Jun 26, 2001

Has anyone had any luck trying to use a central store for server registration information? I'm following the steps but it doesn't seem to work.

I receive the following error: The Server Registration Information could not be loaded - Registry read error:2

Any help is appreciated.

View 1 Replies View Related

SQL 2012 :: Access To Central Backup Location

Dec 11, 2014

SQL Server service accounts; the default (and recommended) service account is NT ServiceMSSQLServer virtual service account - which is shown as MSSQLSERVER locally - if you want to assign permissions to a local location. Fine, that's OK, works.

For network resources, as far as I understand it (or think I do, anyway), a virtual service on a box is made visible to the network using the <Domain><Computer>$ credential. Eg for box Bimble on Domain Wimble - if I want to give access to a directory on backupServer1, I simply assign rights to WimbleBimble$ and SQL Server should get those rights.

This, or so I thought, should allow SQL Server access to that location. The thing is, when trying to access that location, it's throwing an access denied error. But it works fine with LocalSystem.

Do I need to do some additional configuration to allow the Virtual Service account to be shown via <Domain><Computer>$ ?

View 1 Replies View Related

Replication Of Several Satellites Into One Central Db: Adding Location Key ?

Dec 6, 2005

Dear group,i have the following setting:satellite databases in different locations with the same structure (andsometimes identical data) need to be replicated into one centraldatabase. The databases hold information on machine results andmachines are numbered from 1 to n.Results for machine 1 in location 1 should be entered in the centraldatabase whereas results for machine 1 in location 2 should also beentered.Thus i would need a copy of the tables in the satellite database whichadds one column for "location id" (or something like that).Is there an easy way to accomplish this ? Seems to me that thereplication scenarios in the "replication wizard" for SQL-Server missout this case.Some hint at documentation or websites would be extremely helpful.Thanks + Greetings from ViennaUli

View 1 Replies View Related

Report Service Not Showing Up In WSS 3.0 Central Admin

Jan 16, 2007

I installed the Reporting Service for Share Point just fine but when I go to central admin I do not see the reporting service section. Any Ideas?

View 4 Replies View Related

Reporting Services Not Showing In Central Admin

Mar 7, 2007

I downloaded and installed SQL Server 2005 SP2 update on my reporting services server. I think downloaded and installed the share point reporting services admin to my share point dev server. I open up the central administration and there is no reporting services menu option under the Application menu. The sharepoint server is a farm with backend database on one server and all the web apps on the other (where the add-in was installed). The reporting server is a separate server running its own instance of SQL 2005.

Am I missing something with this setup?

View 1 Replies View Related

SP2 Integration Mode Kills Sharepoint Central Administration

Feb 27, 2007

Hi

I had the following setup:

Farm Server 1
* Sharepoint 2007 full install

Farm Server 2
* SQL Server 2005

I installed the following:
* SP2 for SQL Server 2005 on Server 2
* Web-front end install of Sharepoint 2007 on Server 2 - to install the object model
* SSRS2005 reporting services add-in for Sharepoint technologies on Server 2

Since doing that, I can no longer get to central administration on Server 1 - I now get the following error when navigating to central admin:


Server Error in '/' Application.


Runtime Error Description:
An application error occurred on the server. The current custom error
settings for this application prevent the details of the application error from
being viewed remotely (for security reasons). It could, however, be viewed by
browsers running on the local server machine.

Which web.config do I have to edit to get the full error to show, and has anyone else experienced this?

This happened to me when my servers were fully configured and had data - so I rebuilt them from scratch and the same problem occured again!

Adam

View 8 Replies View Related

SQL 2012 :: Retrieve Job History For All The Jobs Using Central Management Server?

Apr 2, 2015

Is there anyway we could retrieve the job history for all the jobs in all the sql server using Central Management Server?

View 0 Replies View Related

DB Design :: Moving All SC Databases From Their Respective Application Servers To A Central One?

May 18, 2015

We are planning to move all of our System Center Databases that reside on front end servers to each system center application to a centrally located SQL 2012 server. We'd like to centralize everything and have our DBA care for the server. here is our setup:

SCOM has 1 monitoring and 1 Data warehouse server. SCCM has 1 server with all roles on it. DPM database is on the same server as Application. Same with SCVMM. I have 2 questions regarding this move:

1. Can I have all these databases running on 1 SQL instance?

2. Is there a best practice document that highlights steps and "gotchyas"

View 4 Replies View Related

Replication :: Replicate All Data From Remote Locations To Central Location

Aug 29, 2015

there are several remote locations where sql is running, my company has asked me to find a way to collect all the data from the remote locations to a central location automatically,for example day to day data should be synced at night time from 2am to 7 am and it should be compressed automatically before data transfers to the central location. NOTE there is no domain only standalone workstations

View 3 Replies View Related

Consolidation - Changing Replicated Data In A Central Subscribing Site

Sep 25, 2006

Hi all,

I am new to replication and have a few questions.

1) Are there any "hooks" available to insert processing when a subscriber is about to copy data from a replicating site?

2) Is it possible for a subscriber to change only his local copy of the data - without replicating the changes back to the publisher?

I realise that once the data changes in one place it isn't really replicated anymore, and I realise that my limited knowledge of the subject might well mean I'm not even asking the right questions. Therefore, I shall try to describe as best I can my scenario.

I wish to use many servers for transactional input (to distribute the workload) and use replication to publish the inputted data to a subscribing central site. One of the tables I wish to replicate has an identity column as primary key, but the records should otherwise be unique - i.e. no two records should differ only in the value of the key. Another table, which should also be replicated, uses this id value as a foreign key.

I can use the identity increment and seed to guarantee no key violations will occur when copying data to the central server. However, there is another issue: Several servers can create the same record but with different id values.

I need to "merge" such records by deleting duplicate entries in the table with the identifier as primary key, and update the foreign keys correspondingly. To clarify (I hope!), here's an example of what data I might have on the central site after copying data from two input sites:

TRANSACTION table

amount = 200, metadata_id = 1001 // Replicated from server INPUT_1

amount = -117, metadata_id = 2001 // Replicated from server INPUT_2

METADATA table:

id=1001 Actitiy=Sales, Country=USA

id=2001 Activity=Sales, Country=USA

What I would like is basically for the central site to identify that metadata 2001 is really the same as metadata 1001, update the foreign key in the TRANSACTION record accordingly and not import (or delete, if this "merging" is done in a post-treatment) the duplicate metadata record.

If anyone can offer any advice on how to achieve this I would appreciate your input.

View 3 Replies View Related

Central Management Server Doesn't Support Multi Domains

Jun 4, 2015

As CM doesn't support SQL authentication, and if access SQL Server on another domain with no trust, we cannot use Windows authentication as well.

CM only supports Windows authentication, but for large organizations which will have multi domains...

View 2 Replies View Related

Unable To Perform Set Server Defaults In Sharepoint 3.0 Central Administration

Apr 12, 2007

I'm not quite sure where to post this question, so I'll try here. We've been struggling getting SQL2005 reporting services integrated with Share Point Services 3.0 for several days now.

We've installed SQL Reporting Services with SP2 and run the SharePoint Reporting Services add-in. We've been able to go through the SQL Reporting Services Configuration and now were at the last step in the SharePoint Application Management Reporting Services configuration.

The first two steps of Manage Integration Settings and Grant Database Access was sucessful. The final step of "Set Server Defaults" gives us a 404 error message. There is nothing in the Event Log to suggest that there was a problem, and the SQL2005 Server is in SharePoint Integration mode. I've searched but can't find a solution. Can anyone steer me in the right direction please?

View 27 Replies View Related

Creating A Database From Multiple Databases Accross Multiple Servers

Sep 13, 2007

Hi,

I'm trying to create a database that takes specific information from a number of databases on different servers to make some reporting that we have much easier.

I'm pretty new to SQL so I'm not sure of the best way to proceed. I read an article that suggested I use the OPENROWSET command. The problem is, the version of SQL that came with one of the programmes we use is limited and will not allow you to turn on the allow "Ad Hoc distributed Queries" so the SLQ statement will not execute.

I'm confused why it won't let me to connect through ODBC as I've created a web page that selects data from this database with no problems!

Here is the SQL statement that I've written to make sure it is the correct one (on the msdn library page it said that this was the ODBC connection):

SELECT a.*
FROM OPENROWSET('MSDASQL','DRIVER=(SQL Server);SERVER=APPOLOACT7;UID=sa;PWD=***************',
'SELECT * FROM MDCTestAndDev.dbo.TBL_CONTACT') AS a



I've also created the ODBC connection using the tool on Administration Tools>Data Sources ODBC

Any help would be greatly appreciated (also any ways of selecting from one database and inserting it into another will be helpfull)

Thanks

View 8 Replies View Related

Replication :: Replicate Data From 3 Publishers To A Single / Central Subscriber Transactionally?

Oct 15, 2015

Is it possible to replicate data from 3 publishers to a single/central subscriber transactionally? In other words I have Server A, Server B, Server C with databases A,B,C respectively. I need to replicate 2 articles from A,2 from B and 2 from C to a central Server D that hosts database D. D will have only 6 articles. The replication is Transactional Replication.

If it is possible what will be the drawbacks of such implementation? (if one server goes down will the whole replication break?) If not possible then what is the best way of implementing this?

View 3 Replies View Related

Central Management Server - How To Send Query Output In The Form Of Mail

Apr 29, 2015

i have used CMS in SQL 2008 R2. i have added couple of servers in its group. i have executed a query & i need to send the query output in the form of email.

basically query is checking the rows count from couple of user tables in servers.

issue here is how to copy the data that is used by CMS? i need to work on automate the rows count in difft user table in db servers.

View 2 Replies View Related

Collect Missing Index Data Into Central Repository From Sys.dm_db_missing_index_group_stats, Groups, Details

Nov 2, 2007



Greetings:
I am trying to gather into a central location the missing index data from the sys DMV's for dynamic index creation in the next step. In trying to use a cursor, I get the following errors:

Msg 154, Level 15, State 3, Line 20

variable assignment is not allowed in a cursor declaration.

Msg 102, Level 15, State 1, Line 94

Incorrect syntax near 'Get_Data'.

Msg 16916, Level 16, State 1, Line 2

A cursor with the name 'Get_Server' does not exist.

Msg 16916, Level 16, State 1, Line 3

A cursor with the name 'Get_Server' does not exist.


Here is the SQL:


--CREATE PROCEDURE usp_Get_Missing_Index_Data

--AS

--Declare @Sql2 nvarchar(4000)

Declare @Sql nvarchar(4000)

DECLARE Get_Server Cursor -- gets a server name from a list of servers

for

Select MachineName from rsqlaudit1.DBStatistics.dbo.servers

Open Get_Server

Declare @Server nchar(20)

Fetch Next from Get_Server Into

@Server

While (@@FETCH_STATUS = 0) --and (@@FETCH_STATUS <> -2)

BEGIN



DECLARE Get_Data Cursor

FOR

select @sql= 'select distinct id.*

, gs.avg_total_user_cost

, gs.avg_user_impact

, gs.last_user_seek

,gs.unique_compiles

from '+@Server+'.master.sys.dm_db_missing_index_group_stats gs

,'+@Server+'.master.sys.dm_db_missing_index_groups g

,'+@Server+'.master.sys.dm_db_missing_index_details id

where gs.group_handle = g.index_group_handle

and id.index_handle = g.index_handle

order by gs.avg_user_impact desc'

exec (@Sql)



Open Get_Data

DECLARE @Handle int,

@database smallint,

@object int,

@equality nvarchar(4000),

@inequality nvarchar(4000),

@Included nvarchar(4000),

@statement nvarchar(4000),

@avg_user_cost float,

@avg_user_impact float,

@last_seek datetime,

@compiles bigint

Fetch NEXT FROM Get_Data INTO

@Handle,

@database,

@object,

@equality,

@inequality,

@Included,

@statement,

@avg_user_cost,

@avg_user_impact,

@last_seek,

@compiles

While (@@FETCH_STATUS = 0) --and (@@FETCH_STATUS <> -2)

BEGIN

insert into rsqlaudit1.DBStatistics.dbo.Missing_Index_data

values (@Server,

@Handle,

@database,

@object,

@equality,

@inequality,

@Included,

@statement,

@avg_user_cost,

@avg_user_impact,

@last_seek,

@compiles)

FETCH NEXT FROM Get_Data into

@Server,

@Handle,

@database,

@object,

@equality,

@inequality,

@Included,

@statement,

@avg_user_cost,

@avg_user_impact,

@last_seek,

@compiles

Fetch Next from Get_Server Into

@Server

END

CLOSE Get_Data

DEALLOCATE Get_Data

GO

CLOSE Get_Server

DEALLOCATE Get_Server

GO

Any suggestions are appreciated.

Thanks,
Derek

View 3 Replies View Related

SQL Server Admin 2014 :: Central Management Server Doesn't Support Multi Domains

Jun 3, 2015

As CM doesn't support SQL authentication, and if access SQL Server on another domain with no trust, we cannot use Windows authentication as well.

CM only supports Windows authentication, but for large organizations which will have multi domains.

I am thinking if there is no proper way/tool, we will develop one then.

View 0 Replies View Related

Multiple Database / Cross Database Referencial Integrity (foreign Keys)

Feb 12, 2008

Using SQL Server Express 2005, I have two databases.  AppDB - The main application database.GeoDB - A somewhat static ZIP code / states / other geographic stuff databaseI need to have some foreign key columns in tables in AppDB reference columns in the GeoDB database tables.  Eventually other application database besides AppDB will be doing the same thing in our infrastructure. After googling and reading for days, here is what I
think I know:You cannot create foreign keys that reference tables in another database in SQL Server.You
cannot create foreign keys that reference columns in a view, and you definitely cannot make an index on a view that has base tables in another database.You can create a trigger that references tables in another database, but this can be flaky?  (nested/recursive trigger problem).SQLServer
2005 supports multiple schemas within the same database.  Maybe I should logically separate my databases this way?  Seems like it would be a tough solution to manage since I already have some databases live in production that will eventually use this 'static' GeoDB.  Also, seems like it
wouldn't be as portable as keeping the GeoDB info in its own database,
but maybe I'm being too software engineer-ish here - afraid of low
cohesion, high coupling.I will greatly appreciate any advice I can get, or any more options I am missing.  Thanks,Adam Nofsingerucnmedia.com

View 2 Replies View Related

Database Design- Referencing Multiple Database

Sep 27, 2007

Hi All,
I am designing database where few of the master tables will reside in different database or in case different server. Scenario is
Server "A" with Database "A" may host the "Accounts" table.
Server "B" with Database "B" may host the "Product" table.
I am designing database "Project" which will hosted in Server "A".
My application requires this master tables [readonly access] as data inserted in my application refers this tables. Also there are reports to be generated which refer this tables.
How do i design my database and sql queries?
I am thinking of approach of having equivalent tables created in my database and writing service which keep tables in my database in sync. This will ensure good perfomance during transaction and reports as they will need to refer this table locally as opposed to different database or different server.

Any thoughts on above approach?? or any better/standard way for such scenarios ?

Thanks in Advance. Your inputs will be of great help.

View 14 Replies View Related

Database Design - Multiple Vs. Single Database

Apr 12, 2007

Hello:

My client has a db with the following structure:

Online US Searchable Map of the 50 US States. Users search criteria is the following: Query records by selecting state, county, then record. Each County table has 10-20 tables. All databases combined = 500MB and TLogs = 100MB.

How would you re-design a relational DB where users could query data by state-county-record. Currenty the DB's are created by the County of each state which creates hundreds of DB's in SQLServer with no realtionship to each US state. What would be the best design to ensure good performance, data integrity and maintenance? Would you create 1 DB with all 50 states, create 4 DB's and divide by region(N,S,E,W), 50 DB's of each state or leave it as is with each county it's on DB? Any suggestions would be appreciated.

thx
rob

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved