Linked Server Option ?
May 11, 2004
Hi Everone,
I'm new here so please bear with me. I'm not sure how to ask this question so I have not done a search yet.
I have a proc that creates select statements on the fly from a feeder metadata table for ten tables at a time, all the time. Until now everything was on one server. Now some of the data tables are on another server, but this is not a problem.
There are some times when one of the tables is missing and the proc throws an error (as it should) and stops the execution of the 9 table builds. When it was all on one server, it would always throw an error and continue. Now when it's reading through a linked server it will not continue.
What can I do ? Thank you all.
Ken
View 4 Replies
ADVERTISEMENT
Oct 26, 1999
I am having problems setting up a linked server in 7.0 Enterprise Manager. I am trying to setup the linked server using the "they will be imperonated" choice for the "For all users that are not defined in the list below" choice on the security tab. All servers I am trying to link to are registered in enterprise manager.
I can setup the linked servers on the source server itself and access tables from the linked servers as long as I am logged into the source server (where the linked servers are defined). E.G. I am logged into server SQL2 and have linked to server TST2. I can see tables from SQL2 in enterprise manager just fine.
However, when I try to access the linked server (TST2) from an enterprise manager running on an NT workstation (NT-RINEHARTS) or a 9x PC than I get the following error:
18456: Login failed for user ''.
It looks like the domain nameusername is not getting passed along to the linked server. Why won't this work from a remotely run Enterprise Manager? IS it supposed to? AM I leaving something out?
Again all linked servers are registered in Enetrprise Manager running on the NT workstation.
View 1 Replies
View Related
Jul 22, 2014
it is possible to create Linked server with Failover partner option. I can query when primary server and getting the error when I set the DB Fail over. I have tried with following script and also gone through different sources, but failed. Please see the script and error below.
EXEC master.dbo.sp_addlinkedserver
@server = N'MIRRORLink',
@srvproduct=N'',
@provider=N'SQLOLEDB',
@provstr=N'Server=primary;FailoverPartner=mirror;network=dbmssocn;',
[code].....
View 2 Replies
View Related
Jul 10, 2001
Im having trouble accessing a linked/remote server from a powerbuilder app.
I can run the stored proc from QueryAnalyzer, but from the app I get the error message - 'heterogenous query must have ANSI_NULLS set option ON, set it and retry'.
Is the ANSI_NULLS option set for each db, or each server? And how can I check a DB or Server to see what the setting for ANSI_NULLS is? Does the local and remote/linked server/db need this option ON?
Any idea why this remote query works form QA but not from an application?
Thanks-
Scott
View 1 Replies
View Related
Apr 27, 2008
Hi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio 2005 Setup.
View 2 Replies
View Related
Mar 25, 2002
Hi ,
On my Desktop i registered Production Server in Enterprise Manager
on that Server if i go to SecurityLinked Servers
There is another Server is already mapped, when i am trying to see the Tables under that one of the
Linked Server i am getting the Error message saying that
"Error 17 SQL Server does not exist or access denied"
if i went to Production Server location and if i try to see the tables i am able to see properly, no problems
why i am not able to see from my Desk top
i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER)
And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem
What might the Problem how can i see the Tables in Linked Server from my DESKTOP
Thanks
View 5 Replies
View Related
Apr 24, 2015
I am using Linked Server in SQL Server 2008R2 connecting to a couple of Linked Servers.
I was able to connect Linked Servers, but I cannot point to a specific database in a Linked Server, also, I cannot rename Linked Server's name.
How to point the linked server to a specific database? How to rename the Linked Server?
The following is the code that I am using right now:
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'Machine123Instance456',
@srvproduct=N'SQL Server' ;
GO
EXEC sp_addlinkedsrvlogin 'Machine123Instance456', 'false', NULL, 'username', 'password'
View 6 Replies
View Related
Jul 18, 2006
Is there a way to bypass the syntax checking when adding a stored procedure via a script?
I have a script that has a LINKed server reference (see below) .
INSERT
INTO ACTDMSLINKED.ACTDMS.DBO.COILS ..etc.
ACTDMSLINKED does not exist at the time I need to add the stored procedure that references it.
PLEASE to not tell me to add the LINK and then run the script. This is not an option in this scenerio.
Thanks,
Terry
View 4 Replies
View Related
Feb 10, 2015
So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.
From Books Online:
• This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician.
• The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.
View 3 Replies
View Related
Jun 6, 2006
First off, I apologize for not knowing what I'm talking about and being long winded. I'm trying to determine if SQL Server Express is an option for a client of mine. Their needs are beginning to go beyond what I'm comfortable with in Access, so I'm looking into the option of upgrading to a SQL Server Express back-end with a VB front-end.
Access doesn't require any setup beyond "File, new", so I know nothing about the background work required to get a database running on a platform like SQL Server.
My first concern is what kind of network admin rights do I need to install & use SSE..
It's unlikely that her IT group will just hand us the keys to any of their servers, so all we really have available is what we can put on her network drives. Am I right in assuming that using a SQL Server database would involve more network privileges than just dropping a file on the network and pointing my front end app at it?
With that said, I think I remember seeing something on one of the MSDN pages about setting up a database to run off of a CD-Rom. Could I somehow use this capability to get what I need?
View 6 Replies
View Related
Apr 11, 2008
I'm using a package configuration to set the value of a user variable which I then use inside my package to build out a certain expression. I got this to work with the XML file option, but I can't get it to work using the SQL Server option.
So this is what Im doing.
(1) I copy pasted the package that works with the XML config option.
(2) In the new package, I deleted the existing XLM config and created a new one, this time choosing the SQL Server option. After I finish, I see that the dbo.SSIS_Configurations table gets created in my database with the value of my variable in there.
(3) I run the package and I see that it works. I'm not sure at this point if it is working because it's reading the value from the config table or from the BIDs environment where I initialized the value.
(4) Anyway, I then go and update the value of my variable in dbo.SSIS_Configurations.
(5) When I run the package again, it doesn't see the new value. What am I doing wrong?
View 22 Replies
View Related
Sep 13, 2001
Dear,
i got solve for my problem later.But I meet with new difficulty,my the following gives example script
------------------------------------------
CREATE TRIGGER Niru_data ON dbo.trans_r
FOR INSERT
AS
DECLARE
@Code_Month char(4),
@name_table char(10),
@noreg char(7),
@tr_date char(6),
@Rec_contain char(20)
SELECT
@Code_Month = substring(tr_date,1,4) from inserted
SELECT
@name_table = "trans_"+@code_Month
SELECT
@noreg = a.noreg,
@tr_date = a.tr_date,
@rec_contain = a.rec_contain
FROM
trans_r a INNER JOIN inserted b
ON
a.noreg=b.noreg
insert into @name_table values(@noreg,@tr_date,@isi)
GO
--------------------------------------------------
That's trigger not succesfull cause i try to insert table with variable declaration (@name_table).
some body can help me ????
Thank you before that
View 1 Replies
View Related
Jul 31, 2002
One of the configuration options that can be set for the server is called "user options". User options contains sub-options such as ansi_warnings, ansi_padding, ansi_nulls, arithabort, etc..
Using T-SQL, how are these set?
sp_configure 'user options', @configvalue = 'value'
go
reconfigue with override
go
i.e. Are the individual option values summed. Say I wanted to set ansi_warnings (whose value is 8) and ansi_nulls (whose value is 32) on and all other user options off. Then is my @configvalue 40?
Sorry, but I don't feel BOL is clear on how to set these options.
TIA Gary
View 5 Replies
View Related
May 26, 2008
Sir
How to used Show Server Trace option.
Where I got this option in SQL server .
Pls Help me .
Yaman
View 3 Replies
View Related
Jan 17, 2007
I'm in VS 2005 trying to access a database running on MS Sql Server Express 2005 (local machine). In VS i choose Data | Connect to Database | and then i select change on the Add Connection Dialogue box. For some reason I'm only given two options which are the following:
MS Access Database File or MS SQL Server Database file. I've seen options in books showing MS SQL Server but that doesn't show as one of my options. I'm running the Server express locally and can access it through my Management Studio Express as localmachinesqlexpress.
Is this a limitation of Express or do i need to adjust some options in the IDE?
Any help would be great.
jeremy
View 2 Replies
View Related
Feb 4, 2004
I'm pretty new to MSSQL. We have SQL 2K and I was wondering if anyone has seen this issue before.
When I create/modify an Alert there is no option for "SQL Server Performance Condition Alert" in the Type under General tab.
Has anyone seen this before? What can I do to get this type of Alerts?
Just a note -- on my other SQL servers they have the options.
thanks in advance !
View 5 Replies
View Related
May 26, 2006
In SQL Server 2000, can you enable an option to check password retries? For example if an SQL Server ID logs incorrectly 5 times, you disable the login account.
Any help would be greatly appreciated. Thanks.
View 7 Replies
View Related
Mar 20, 2015
I just inherited a few Servers that have SQL Server 2000.
I cant find the new query Icon?
[URL]
View 2 Replies
View Related
Jul 20, 2005
I'm having problem with locking in update and select.my update takes long and select from clients happens all the time.I know with NOLOCK in select or set transaction isolation level, I canread data uncommited.I want to know if there is an option I can change on server ordatabaseto change isolation level for all incoming connections.thanks for your help in advance.
View 6 Replies
View Related
Jul 15, 2007
Hi,
I'm trying to install SQL Server 2005 onto my XP Professional PC. When I get to the "Components to install" part, the "SQL server database services option" is greyed out. Infact, all options except "Workstation components..." are greyed out. I've tried uninstalling all previous versions of SQL server and trying again, but with the same results.
any help would be much appreciated
Simon
View 5 Replies
View Related
May 26, 2008
Hi All,
Use Case1:
Just wanted to know if there is something like multiple cascade delete option in SqlServer 2005.
My table structure is similar to what is given below
create table test ( id int PRIMARY KEY, tname nvarchar(55))
create table childTest ( id1 int REFERENCES test(id) on delete cascade,
id2 int REFERENCES test(id) on delete cascade, tname nvarchar(55))......
The above creation fails for childTest since both id1 and id2 reference test with ondelete cascade.
As per Books online: The series of cascading referential actions triggered by a single DELETE or UPDATE must form a tree containing no circular references. No table can appear more than once in the list of all cascading referential actions that result from the DELETE or UPDATE.
Doesn't look like a circular reference here. Wanted to confirm if it is because test is being referenced twice in the childtable.
My requirement is if a row is deleted from test, it should delete matching rows from childTest(id1 and id2). Since delete cascade is not being allowed for both columns , I have to handle the delete in id2.
Use Case2:
Also can I have INSTEAD OF DELETE and Cascade delete on the same table?
I have a cascade delete from table1 to table2. which means when any row from table1 is deleted corresponding rows from table2 are deleted. and on table2 I would like to have an instead of delete where I would like to delete rows from another table say table3.
Thanks & regards
Sunil
View 4 Replies
View Related
Mar 13, 2008
Ok, I need to test my webservice with the 'use custom server' option on so that I can specify a base URL that I can reference from apps on a remote machine. I have a connection string I am using to access a sql server db that has Integrated Security=true and windows login has a login for it created in the db.
However, whenever I try to call a webmethod I get this error:
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
But when I call the same webmethod specifiying a sql login / pw, and not integrated security, my webmethod works.
I want to use integrated security though, please help!
View 2 Replies
View Related
Sep 14, 2007
Hi,
When i try to deploy a Datasource which is using a report server model, i dont see the Deploy
Option Enabled. It is disabled for Report Server Model.
My connection string is server=http://localhost/reportserver;datasource=/i2i Report Model/SCM Data Warehouse Model
Can anyone point me to the issue here ?
Thankyou
Vidya
View 1 Replies
View Related
Mar 22, 2007
I need to create a job and schedule it in sql server 2005.But the sql server agent option doesnt come under the database instance in the object explorer.Do I have to instal some other component of sql server 2005?
View 1 Replies
View Related
Oct 4, 2007
I am creating reports in sql server reporting service 2005, After getting reports when we give the print option system will be restarted. But this report is properly printing in Internet Explorer6 but ie7 it cannot work.I don't know why this happened? please give any suggestion.
View 1 Replies
View Related
May 29, 2007
Hi,
Is it advisable to use full text search on asp.net live applications? Will live database servers allow full text search?. If so what are the problems we could face in future.
My DB server is SQL Server2000 and ASP version is 1.1.
Thanks in advance
Hamlin Stephen
View 4 Replies
View Related
Jul 22, 2015
I have come up with an issue where I want to update data in a table using bulk/SET update to get the result shown in below code with output in column titled "Arrear Amt".
Please use this test data.
CREATE TABLE ##vOD_Calc
(
Seq_No INT ,
Contract_id INT ,
Rental_id INT ,
Actual_OD INT ,
Logic_OD INT ,
Due_dte DATETIME ,
[Code] .....
Logic required is that once the sum of column [ArrearAmt] of current row and all previous rows becomes greater than $100 then column [ChArrrearAmt] should show that summed up value and in else case the column [ChArrrearAmt] should show the same value as that of column [ArrearAmt].
Once the column [ChArrrearAmt] reaches the threshold of $100 then the same cycle should start again i.e. in above example rental#1 had $37.17 < $100 then rental#1 + rental#2 is also < $100 and at rental#3 sum of rental#1, rental#2 and rental#3 becomes $111.51 which is greater than $100 so its updated in column [CHArrrearAmt]. The same cycle start overs from rental#4 onwards however the summation of [ArrearAmt] will now begin after rental#4 onwards and not from the starting.
Below is the loop based SQL script which handles the above situation, however in BULK its a total deterioration of performance if thousands of rows are to be processed i.e. with a contract having multiple rentals.
The case here is that I have to use the result of previously updated column value of [ChArrrearAmt] to take decision for the next row, however with BULK update since the row is not yet updated with latest amount therefore the decision on next row is also giving wrong result.
This is the code with which I have achieved to update the column 'chArrear Amount', however its a loop based solution and performance killer.
INSERT INTO ##vOD_Calc_loop
( Rows_count ,
contract_id
)
SELECT COUNT(*) ,
T.Contract_id
FROM ##vOD_Calc T
GROUP BY T.Contract_id
[Code] ....
View 4 Replies
View Related
Aug 4, 2015
I don't want to any body can backup of my database, even i can also not able to take backup.
View 17 Replies
View Related
Jan 21, 2008
Hi All,
I want to deploy my reports in a Sharepoint site. So I need to change the Deployment mode from Native to Sharepoint Integrated mode. When go to Reporting Services Configuration and in Database Setup - the Server Mode option is not visible. Anyone help me what is the reason for this or How to get Server Mode option in Database Setup in Reporting Services Configuration menu. However the system installed with Sharepoint and SSRS SP2.
Thanks in advance,
Senthil
View 4 Replies
View Related
May 29, 2014
I am running a query on SQL 2012 Server with the Resource governer setup for my account to have Max DOP option set to 1.
The query still runs in about 1 minute and the execution plan still considers parallelism.
When I explicitly mention the OPTION (MAXDOP 1) , the query runs in 6 seconds.
How can i tell by querying DMV's whether my query is using parallelism or not?
View 2 Replies
View Related
Feb 26, 2007
I am trying to install SQL Server 2005 using command prompt. I have gotten the latest download. My question is what is the commad prompt for the tag ADDLOCAL for SQL Server Management Studio Express. For SQL Server datatbase it is called SQL_Engine. In the same way what should I be using for "SQL Server Management Studio Express". I want to limit the choices that are installed on the user machines.
Any help is greatly appreciated.
Thanks,
Mahesh
View 1 Replies
View Related
Jun 21, 2007
Hi All,
I want to import a txt file data to a sql server database table, to do this i used sql server import and export wizard. In this when we choose a Data Source, the option Flat file source is not coming up in the combo box in the wizard.
I am using sql server 2005, Management Studio to do this.
steps 1. right click on the database --> all tasks --> import data --> sql server import export wizard --> choose data source dialog box....
please help me.
thanks in advance.
View 1 Replies
View Related
Apr 18, 2008
1Is it possible to choose local user,(instead of local system) in sql setup service login and then use mixed mode
default configuration in report server or choose configure server later. I will be using a third party host using vista, unfortunately I do not have my own server ( I do not have a domain yet)
vista sql 2005 standard vs 2008. ultimate
2 What is the best configuration for a new aspiring asp.net ssrs developer.
3 Do I need to configure the server if I choose local user?
4. what is the best way to configure sql?
By the way what items
should I look forward in choosing a web host,(who is willing to give alot of help to developers) my interests include ssrs 2008 sql 2008 sql 2005
asp.net mvc, crystal reports, wcf infragistics. I am really interested in showing
examples in sql reporting services, crystal reports wcf , web services , infragistics
asp.net mvc intrigues me.......
I would like to get on a track to eventually use sharepoint services
Thanks again, I know I ask I alot of questions........
View 3 Replies
View Related
