Configuration Error...name Wanted

Nov 30, 2006

Hi, does somebody recognize the problem with my code? -Thanks!  

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: This is an unexpected token. The expected token is 'NAME'. Line 58, position 52.

Source Error:  

<sessionState mode="SQLServer"stateConnectionString="Jensen"sqlConnectionString=

"datasource=Database;userid=username;password=pass"cookieless="false"timeout="60"/>

View 1 Replies


ADVERTISEMENT

SQL Guru Wanted

Aug 2, 2006

Ok guys I have read everything in my previous post but unfortunately can not seem to get it to work properly. Would anyone like to do this 10 minutes work (I am sure). Obviously I dont expect it to be free but if I continue I am going to get a sledge hammer to this now.

Thanks in advance

View 20 Replies View Related

SQL Developers In Seattle Wanted!

Sep 23, 1999

Always looking for people who are strong with microsoft technology for new oppurtunities in the Seattle area. If you are good, we can help you find your ideal next position.

don't be shy. shoot me an e-mail.

thanks

Pat Copeland

View 2 Replies View Related

SQL Developers In Seattle Wanted!

Sep 16, 1999

I am looking for strong SQL developers and/or DBA's for some really sweet companies here in Seattle. Anyone interested that is good and wants to hear about new oppurtunities? I would love to help you out.

don't be shy just shoot me an e-mail.

View 2 Replies View Related

VC++ Code Example For Extended SP - WANTED

May 8, 2002

Please help to find an example of the code written on VC++ for an extended stored procedure (dll) for SQL Server 2000.

Thanks

View 1 Replies View Related

Everything You Wanted To Know About Blocking...but Were Afraid To Ask

Mar 19, 2004

OK...this is driving me nuts....

In the First DELETE and bcp I was getting the thread being launched by xp_cmdshell was being blocked by the parent thread...

put in WAITFOR...sometime it worked...started with an empty table..it worked....left the 28k rows, blocked...

Now, put SELECT COUNT(*)...works each and every g-d damn time...

HUH?

Now I get to the bcp out..

added the same code WAITFOR/SELECT *...

blocks each and ever g-d damn time....

I'm very reticent to COMMIT and start another tranny block...

Anyone have any ideas?



SET NOCOUNT ON

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[wrk_DataHold]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[wrk_DataHold]
GO

CREATE TABLE wrk_DataHold(Col1 varchar(8000))
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[wrk_OldNew]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[wrk_OldNew]
GO

CREATE TABLE wrk_OldNew(Old varchar(255),New varchar(255))
GO


INSERT INTO wrk_OldNew(Old,New)
SELECT 'SEVERAL EE~S', ''
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_ModifyRows]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[usp_ModifyRows]
GO
CREATE PROC usp_ModifyRows
@Path sysname
, @FName sysname
AS

SET NOCOUNT ON

BEGIN TRAN

DECLARE @cmd varchar(8000), @Servername sysname, @rc int, @error int, @rowcount int
, @Old varchar(255), @New varchar(255), @x int

CREATE TABLE #bcpLog(Col1 varchar(8000))

SET @rc = 0

DELETE FROM wrk_DataHold

SELECT @error = @@error, @rowcount = @@ROWCOUNT
IF @error <> 0
BEGIN
SET @rc = -1
GOTO usp_ModifyRows_Error
END

SELECT @x=COUNT(*) FROM wrk_DataHold
WAITFOR DELAY '000:00:10'

SET @cmd = 'bcp wrk_DataHold in ' + @Path + @FName + ' -S ' + @@SERVERNAME + ' -U -P -c'
INSERT INTO #bcpLog(Col1) EXEC master..xp_cmdShell @cmd

DECLARE OldNew CURSOR FOR SELECT Old, New FROM wrk_OldNew

OPEN OldNew

FETCH NEXT FROM OldNew INTO @Old, @New

WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE wrk_DataHold
SET Col1 = REPLACE(Col1,@Old,@New)
WHERE Col1 LIKE '%'+@Old+'%'

SELECT @error = @@error, @rowcount = @@ROWCOUNT
IF @error <> 0
BEGIN
SET @rc = -1
GOTO usp_ModifyRows_Error
END

INSERT INTO #bcpLog(Col1)
SELECT 'REPLACE "'+ RTRIM(@Old) + '" With "' + RTRIM(@New)+ '"' UNION ALL
SELECT '('+CONVERT(varchar(25),@rowcount)+' row(s) affected)'

FETCH NEXT FROM OldNew INTO @Old, @New
END

CLOSE OldNew
DEALLOCATE OldNew

SELECT @x=COUNT(*) FROM wrk_DataHold
WAITFOR DELAY '000:00:10'

SELECT @FName = SUBSTRING(@FName,1,CHARINDEX('.',@FName)-1)+'.new'

INSERT INTO #bcpLog(Col1)
SELECT 'Preparing to Write out new file '+ @Path + @FName
/*
SET @cmd = 'bcp wrk_DataHold out ' + @Path + @FName + ' -S ' + @@SERVERNAME + ' -U -P -c'
INSERT INTO #bcpLog(Col1) EXEC master..xp_cmdShell @cmd

SET @cmd = 'bcp #bcpLog out D:cpLog.txt -S ' + @@SERVERNAME + ' -U -P -c'
INSERT INTO #bcpLog(Col1) EXEC master..xp_cmdShell @cmd
*/

COMMIT TRAN

usp_ModifyRows_Exit:

SELECT * FROM #bcpLog
DROP TABLE #bcpLog
SET NOCOUNT OFF
RETURN @rc

usp_ModifyRows_Error:

CLOSE OldNew
DEALLOCATE OldNew
ROLLBACK TRAN
GOTO usp_ModifyRows_Exit

GO

SET NOCOUNT OFF

View 5 Replies View Related

No Recovery/no Log File Wanted

Feb 8, 2006

I have a SQL Server (Express) database that I use in a Visual Studio (Visual Basic) 2005 application.

The application is of the Decision Support type, that routine deletes the contents of some of the database tables and then re-populates them with new data. There is no reason for keeping the "old" contents and no reason to restore the old content.

(It does this using "BULK INSERT" statements, as in:

"BULK INSERT SharePrices FROM "C:SharePrice.txt")

Because of all the data replacing, the log file gets huge quickly. I don't need the log file at all.

(I suspect that the logging is also taking up time unncessarily.)

Is there any way I can set the database not to have a log file at all, or to have a small log file?

(I've tried deleting the log file from SQL Server Management SQL Express, but get a message that there has to be a log file.)

When I restrict the log file size, my application returns error messages that the log file is too small, and the application can't do what it needs to do.

I have already made sure that in the database that the recovery mode is set to "Simple" and that "AutoShrink" is set to true.

I've tried manual "Shrinks". These work. However, as soon as the application accesses the database, the log file gets huge again.

I realise I may have to do (unnecessary) backups before/after my bulk insert statements. If so, I'd appreciate some help on how to do this from within a Visual Basic 2005 application. (I'm actually using the Data Access block from the Enterprise Library for my data access.)

I'd really appreciate your help.



Kind regards

Reg Bust

View 3 Replies View Related

Sample Coding Wanted!

Oct 31, 2007

Dear all,

Can anybody provide sample t-sql procedures coding to do the following tasks?

I want to call a sql stored procedures with parameter passing. I write down the pseudo codes as follows:

In the SQL server side, write a stored procedure which performs the following:

With input parameter "ABCDE";
execute SQL statement "select * from table A where tableA.field B = "ABCDE";
For each record from the result of the above SQL statement,
"select * from tableB where tableB.field C=tableA.fieldX"
if the record can be found in tableB,
"update tableB set tableB.fieldD=something";
if the record cannot be found in tableB,
"insert a new record in tableB"

My actual application requirement is that I have an input file of over hundred thousand records which acts as a primary file to update or to add records to another file. My client side application, which is VB.NET, call a sql procedures once to perform this task. I don't want the VB.NET program to loop through all the input records and call a sql procedure a hundred thousand times!


thanks in advance!

View 8 Replies View Related

Row Info Wanted In Column (like Cube)

Aug 26, 2004

Hi

I have a table called tblsample, where i have information stored row wise. Ther four quarter information is stored for many years. I want those information column wise for a given year.

say

select col1, col2 from tblsample where rqtr=1 and ryear = 2000
select col1, col2 from tblsample where rqtr=2 and ryear = 2000
select col1, col2 from tblsample where rqtr=3 and ryear = 2000
select col1, col2 from tblsample where rqtr=4 and ryear = 2000

i want information like

for the Year 2000

1 qtr 2 qtr 3 qtr 4 qtr


How to acheive this in MSSQL 2000

View 3 Replies View Related

Wanted: Sql Shopping Cart Resources

Sep 30, 2005

hi! I'm still fairly wet behind the ears when it comes to databases, especially sql server 2000. But I just got a copy from my University and I really want to spend some time messing with it. The first thing I want to try is making a shopping cart that stores the items in the database rather than in the session. I'm using asp.net (VB) and I had previously made a simple shopping cart for a SMALL site that stored all the information in a dataset stored in the session... but I've been told that isn't a good idea and reccomended I store the data in the sql database. so that's what I want to do!

I'm looking for resources that can help me get this started. These are the first questions I have about this approach, and any advice from you experts would be most appreciated!

1) do I store the data in a temporary table or do I use the regular table and make temporary rows? if the former how do I transfer the rows from the temp table to the order table? if the latter how do I change it from temporary to peromanent? in either case, how do I eliminate rows if the user abandons their cart?

2) how do I first initialize an order and keep track of the orderID for each user and ensure that no one is assigned a duplicate orderID?

those are my biggest confusions about this approach. I've looked for books on this but most are either too much about sql syntax and big-time server management, or they are too general and not specific to sql server. I've tried looking online, but I can't find much information on doing this using asp.net 2.0. thanks again for your help!

-SelArom

View 6 Replies View Related

Sql Server Certifcation Website Wanted

Jul 20, 2005

I am looking for sql server certifcation questions any one hasany.like dumps or some thing

View 1 Replies View Related

Explanation Wanted About The Service Principal Name ( SPN )

Jun 26, 2007

Hello,



In the ErrorLog of my Sql Server , i found this line :

2007-06-26 05:35:18.37 Serveur The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.


Operating System XP Home SP2

SQL Server 2005 Express Edition with Advanced SP1 )



( idem for another workstation with XP Pro SP2 and same version of SQL Server 2005 Express



My problem is :

i want use the windows authentification but my computers are on Worhkgroup linked by a router ( no window server )

i have read that's possible to connect from a remote computer to a computer having a SQL Server 2005 Express through SPN

How can i do it ? ( activating NTLM ? but how ?)

I'm writing a C# program which must be executing on several computers with a SQL Server 2005 Express installed on a particular computer. These computers will belong to a domain of Windows Server 2003.

As i can't connect to this "normal" network, i am trying to simulate this network at home because i want to test this program and especially the possible locks problems.

I don't know whether i'm querying with the "correct" forum.

Sorry for my poor english.

I shall appreciate any help about this problem

Have a nice day

View 1 Replies View Related

Some Guidance For An SSIS Newbie Wanted

Apr 27, 2006

Hi!

I'm new to SSIS (and quite new to SQL Server). I have a process which I'd like to automize via SSIS - just don't know how and couldn't figure it out yet by playing around with the program. Shouldn't be too difficult though.

First of all, that's the process as I do it now:

1) Load several flatfile sources (dumps of SQL tables) into an SQL database.
2) Add identifier rows (to some tables), set the primary and foreign keys so the database is "recreated" and I can work on it.
3) Do several simple transformations, aggregations and selects across tables and finally write a new table containing information for reporting stuff.

I succeded in loading flatfiles within the data flow view, doing some transformations and saving the output to a flatfile. What I didn't find out: how can I "recreate" the database enabling me to perform "SELECT/FROM/WHERE" statements across tables? Will I have to write the imported files to tables within a db (how?) or can I avoid this step?

A little guide (newbie friendly) would be great help!

View 11 Replies View Related

Report Hiding Duplicates, Not Wanted

Apr 16, 2007

I created a report which has duplicates on one field. I want the report to display the duplicates, but cannot figure out how. Anywhere I have found where there is a "Hide Duplicates" option I have it turned off (in matrix properties), but the report matrix still hides the duplicates. I don't understand why this would happen since the other fields on the same record are not duplicates. I tried grouping but that was no help.

The query in the dataset DOES return the duplicates as expected.



Anyone know how to fix this, or if it is a bug?



Thanks,

Chris

View 1 Replies View Related

Error Log Configuration

Oct 5, 2004

Hi. I'm debugging our application, and I need to see the Sql Server 2000 error log files. The problem is that the Sql Server Engine does not log every error that occurs.
For example, when I run a query "Select * from kkk", it gives an error saying "Invalid object name 'kkk'", but the error is only returned to the client. Its not logged in the error log files. I think, that this happens because that error has a low level (16), and the log is only for high-level errors.
Is there a way to configure which errors are logged in the error log, or to make all errors get logged??
Thanks!

View 2 Replies View Related

Configuration Error

Jul 19, 2007

I installed the SQL Server Management Studio Express successfully. However when I tried to run the Configuration Tools -> SQL Server Configuration Manager", I have an error that asked me to send report to Microsoft (I am sure it's familiar to all) with this message "sqlwtsn.exe" error. I tried on 2 machines but same results. Went thru few times uninstall and install but to no avail.



Also, I have installed the dotnetfx and msxml6 but still unable to get it work. I am running XP SP2, one Pentium and AMD machine. 512 MB. Please HELP!!! Any other alternative? I am running some project for my school assignments urgently. Thanks in advance for the advice.

View 2 Replies View Related

SQL Configuration Error

Mar 18, 2008

When i open up configuration area i click Surface Area Configuration for Features, a few seconds later i get the message:




Code Snippet
TITLE: Surface Area Configuration
------------------------------
Failed to connect to server localhostMICROSOFT##SSEE. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------







Since i was trying to set this up for development purposes i opened the Local TCP ports and configured the firewall to allow SQL traffic through. I went to my application and it successfully connected to the database. So it leaves me wondering if this error i have would make any difference later - can anyone advise how to resolve?

So far i have allowed local remote connections via TCP, ive adjusted the firewall accordingly (which allows other computers to connect to the server and retrieve database information). Im running Windows Server 2008 with SQL 2005 64 bit edition.

Thanks

View 4 Replies View Related

WMI Configuration Error

Jul 7, 2006

Hi,



I tried installing the SQL Server 2005 evaluatio nedition as well as the free Express edition downloadable from the SQL Server 2005 site, and in both cases I got the following error msg:



TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine MYPC Error:2147749891 (0x80041003).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342

------------------------------
BUTTONS:

OK
------------------------------


I cannot figure it out. Some posts suggested using a particular batch file. I did, but it didn't make a difference. Any ideas on what I can do?



Thanks!

Ste

View 4 Replies View Related

SELECT Statements Not Providing Results Wanted

Apr 10, 2002

I have three tables, Employer, Customer and CustomerEmployer. The employer table contains all employers and the customeremployer table contains customer records for an employer. For example

Employer Table
EmployerID Name Address
1 ABC Company 123 Main Street
2 CDE Company 1 South Street
3 JJJ Company 3 Timothy Street
4 ZZZ Company 2 Rust Street

Customer Employer Table
ID EmployerID CustomerID
1 3 1
2 3 2

Customer Table
ID Name
1 Joe Smith
2 Jane Thomas
3 Tim James

I would like to run a select statement which lists all the employers and whether the employer has already been assigned to a customer. For example, for Joe Smith I would like to see all the employers listed AND some marker indicating that Joe is already assigned to EmployerID 3, JJJ Company.
Results
EmployerID Name Address CustomerID
1 ABC Company 123 Main Street
2 CDE Company 1 South Street
3 JJJ Company 3 Timothy Street 3
4 ZZZ Company 2 Rust Street

I have tried unions and many types of joins but none seem to work correctly. I was using the following select statement however only employers that are contained in the customeremployer table appear.

SELECT Employer.EmployerID, Employer.Name, Address, Employer.City,
CustomerEmployer.CustomerID
FROM CustomerEmployer RIGHT OUTER JOIN
Employer ON CustomerEmployer.EmployerID = Employer.EmployerID
WHERE (CustomerEmployer.CustomerID = @customerid) OR (CustomerEmployer.CustomerID IS NULL)
ORDER BY Name

Any ideas?
Thanks.

View 1 Replies View Related

Help Wanted Msaccess PIVOT-query --&> MS-SQL View/sp

Jan 18, 2006

Can someone help me parsing this ms-access PIVOT sql-statement to ams-sql-server sql-statement?Many thanks in advanceTRANSFORM Count(KlantenStops.id) AS AantalVanidSELECT KlantenStops.Uitvoerder, KlantenStops.KlantFROM KlantenStopsGROUP BY KlantenStops.Uitvoerder, KlantenStops.KlantPIVOT DatePart("m",leverdatum,1,0) In("1","2","3","4","5","6","7","8","9","10","11","12");

View 3 Replies View Related

People Wanted: Enroll Now To Help To Make SQL Server Even Better!

Apr 14, 2006

SQL Server Usability Enrollment

Your opinions count.

The SQL Server Design and Usability team invites you to spend a few hours with us and our products (SSMS, SSIS, SSAS, SSRS, BIDS and etc) and tell us what you think. We are interested in how you interact with the products. The information we gather is directly translated into product design improvements, so your feedback makes a difference.

We periodically conduct lab research on campus as well as site visits on various aspects of SQL Server. Your involvement is extremely valuable to us. If you are working with
administering SQL Server databases, building database applications, performing BI
related tasks - we'd like to hear from you.

Please take a couple of minutes to fill out the SQL Server Usability Enrollment form. Your contact information is extremely confidential and will only be used by our team for usability and research purposes. Thanks for your help to make the SQL Server even better!

Microsoft SQL Server Design and Usability

View 1 Replies View Related

All I Wanted Was To Submit Customers Info To My Emailbox

Jan 28, 2008

I have created an order form for my business. I placed a submit button at the bottom. I wanted all the clients information to go into my emailbox. Someone told me about MS SQL Server. I got excited and downloaded the 2005 Express version with all the trimmings. Now I am more confused than I was before. Someone please explain to me what I should do first. Redo the form with the studio then work with the server? I think I may have deleted something important from the server trying to figure it out. Help!!!!!!!!!!

View 7 Replies View Related

Guides On Setting Up Schema For A Database Wanted

Jan 16, 2008

In my SQL Server 2005, we stored multiple application tables in a single database. All of them is using the dbo schema in the past.

Now, we would like to change this practice and adopt a better one. However, we got some problems in the configuration.

If I want to create such a database, should I first create multiple logins and multiple users for all the application. The mulitple logins are used in the connectionstring of my web. While each login can only have 1 user in a database, I need to create a user for each login as well. (Am I correct in doing so? It seems a bit messy.)

The other problem is what should the database role of all that users? If I don't grant them the db_owner. They can't create the required tables. If I grant it, it voliate the intension of separating different application...

Please help. I am a bit lost on this now. Thanks!

View 1 Replies View Related

People Wanted: Enroll Now To Help To Make SQL Server Even Better!

Apr 14, 2006


SQL Server Usability Enrollment

Your opinions count.

The SQL Server Design and Usability team invites you to spend a few hours with us and our products (SSMS, SSIS, SSAS, SSRS, BIDS and etc) and tell us what you think. We are interested in how you interact with the products. The information we gather is directly translated into product design improvements, so your feedback makes a difference.

We periodically conduct lab research on campus as well as site visits on various aspects of SQL Server. Your involvement is extremely valuable to us. If you are working with
administering SQL Server databases, building database applications, performing BI
related tasks - we'd like to hear from you.

Please take a couple of minutes to fill out the SQL Server Usability Enrollment form. Your contact information is extremely confidential and will only be used by our team for usability and research purposes. Thanks for your help to make the SQL Server even better!

Microsoft SQL Server Design and Usability

View 1 Replies View Related

The Annoying WMI Configuration Error

May 10, 2006

I'm recieving the following error:

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine 'machine information' Error: 2147749896 (0x80041008).


I've researched the error and found out some people were running batch scripts to reinstall wmi, but none of them worked for me. One of them I gave up on after thirty minutes and it wasn't doing anything.

Please give some suggestions on how I can resolve this issue.

View 13 Replies View Related

Error After Package Configuration

Jul 2, 2007



I have a package that executes succesfully before package is configured.

but when package is configured to use configuration details either from SQL Server configuration table or XML configuration file, gives an error :



[Connection manager "XYZ"] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".



Can anyone help me out with this ?





Experts !!! this is my second post, my previous post is still unanswered.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1793362&SiteID=1

View 7 Replies View Related

Package Configuration Error

Oct 16, 2007



I have a package that executes succesfully before package is configured.

but when package is configured to use configuration details either from SQL Server configuration table or XML configuration file, gives an error :



Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".


I am using Hit Software OLEDB provider for DB2/400 Connection


Can anyone help me out with this ?

View 10 Replies View Related

Publication Configuration Error

Feb 7, 2006

Hey Everyone,

I am trying to setup publishing on SQL Server 2000 Enterprise. I will be subscribing from a SQL Mobile 2005 database so I have installed the SQL Server 2000 SP3a Replication Components, .NET Framework 2.0, and the SQL Server 2005 Mobile Edition Server Tools.

I was able to go through the 2005 Mobile Web Synchronization Wizard with no problems. However, when I try to run the Configure Publishing and Distribution Wizard, I get the following message at the end:

SQL Server Enterprise Manager could not configure 'GISSERV' as the Distributor for 'GISSERV'
Error 14114: '(null)' is not configured as a Distributor.

The first option I choose is Make 'GISSERV' it's own Distributor. Then, I select the snapshot folder that I shared. And on the third screen, I've tried going with the standard default settings and customizing those settings.

Has anyone else come across this error? Is there anyone else out there replicating from SQL Server 2000 to SQL Server 2005 Mobile?

Thanks in advance,

Lee

View 5 Replies View Related

Package Configuration Error

Apr 4, 2007

Not sure if you guys have run across this error. I created a simple SSIS package to import from a csv file into SQL Server, and I made it configurable so I can point to any of my 4 destination SQL Servers.



In the error list pane, i'm getting this warning:



Warning loading Package.dtsx: Table "[dbo].[SSIS Configurations]" does not have any records for configuration. This occurs when configuring from a SQL Server table that has no records for the configuration.



The funny thing is, the table is populated with 2 properties, Catalog & ServerName, but at run time, its like the Package ignores the SQL table to apply configuration properties.



Any help would be greatly appreciated.



-- J

View 3 Replies View Related

SQL Error In Configuration Wizard

Aug 15, 2006

I am having trouble installing and start SQl server on my machine. Currently, I am running Windows XP on my computer with service Pack 2. Not sure why but every time I try to execute the configuration instance , the start services portion does not execute and I get an error 0 message. Please help!!

View 4 Replies View Related

Package Configuration Error

Feb 4, 2008

Hello Again

I have sql server 2005 installed in my pc. I have to make a DTS package. I did it and it works fine. I have to create a configuration package.

I made it but when i try to debug it, the package show an error in the connection to the database. Checking the xml file all is correct. I tried to change all parameters but it's the same.

Any one knows why it happens?

Thanx

View 4 Replies View Related

After Merge Replication - Wanted To Remove Rowguid Column

Jul 28, 2001

Hi all,

After I setup the merge replication in SQL SERVER 7.0, there is a rowguid column (datatype uniqueidentifier) inserted into each table in the both the source and destination database.

I need to get rid of the rowguid column in all tables. I deleted the replication, but the column still existed.

Is there an easy way to get rid of all the rowguid column in the database? Thanks for your reponse in advanced.

View 2 Replies View Related

Wishlist: MOST WANTED Tasks, Sources, Transformations, And Destinations?

Dec 5, 2005

Until there's an Integration Services 2.0, what custom components would you most like to see examples of? The documentation team is starting work on the 2nd Web refresh of Books Online and SQL Server samples, anticipated for release around April, and may be able to incorporate some requests as samples or BOL topics.

View 26 Replies View Related







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