Answer Questions

• matt01 SQL Server does not exist or access denied

  Hi,  I have developed a small application using VB6 on Windows XP. Following is the code snapshot. I have added Microsoft ActiveX Data Objects 2.1 Library through Project Reference for ADODB Connection. Public con As New ADODB.Connection Public Sub Main()     Set con = Nothing     With con        .CursorLocation = adUseClient        .ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SCMSUG;Data Source=Admin\local"        .Open     End With End Sub I tried above code for connecting to a remote SQL Server database on LAN. But it is giving me t ...Show All

• Raulsassaa SQL Express Activation\Registeration

  Do you have to activate SQL Express once it is installed Do you have register SQL Express after 'x' no. of days after it is installed No, you don’t have to. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Beyond Blue GetDataDrivenSubscriptionProperties vs GetSubscriptionProperties

  Is there a similar method for Data Driven Subscriptions like there is for plain subscriptions ListSubscriptions. I would like to get SubscriptionID for use with the GetDataDrivenSubscriptionProperties just as I do for GetSubscriptionProperties. When I execute GetSubscriptionProperties for Data Driven Subscriptions there is no array of Subscriptions. Here is an examole of the code which I execute using rs.exe: Sub Main() 'Dim rs As New ReportingService() 'rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim DRPlan As DataRetrievalPlan Dim extSettings As ExtensionSettings Dim desc As String Dim active As ActiveState Dim status As String Dim eventType As String Dim matchData As Str ...Show All

• Mateusz Rajca Date between

  Hi to all, What is the best way to check if a dateTime is between two other dateTimes (including the first one, excluding the last one), without taking into account hh,mm,ss and smaller Thanks, Nele If you do it like that, how is the search process in the database then I can have 10000000 records, if it needs to consult them all, the performance will drastically decrease, I think u can use the between operator to do this..it takes both start and in into consideration, but to exclude the last date just reduce a day from that...else u can always use > and <= for comparison...to get just date part of it , use the conversion...an example declare @date a ...Show All

• mnoon connectivity issue

  hey there I hope I have posted in correct forum - please let me know I have 1 XP box - SQL Server Standard 2005 - running IIS (Server 1) I have 1 XP box - SQL Server Express - running IIS (Server 2) script called (test) Server 1 can host web pages eg aspx and collect data from Server 2 (noted in web.config) http:\localhost\test or http:\Server 1\test - either collect data and display Server 1 cannot go to http:\Server 2\test - error default settings do not allow remote connections. Server 2 cannot host web pages and collect data from Server 1 - error default settings do not allow remote connections. Is this because Server 2 has Express Edition thanks Dianne Hi ...Show All

• Jane Sathyan Sql Server 2005 Timeouts

  Getting an issue with SQL Server 2005 in my production environment and wanted to see if anyone else has seen similar behavior. First the environment: SQL Server 2005 on the backend, main site is running on ColdFusion 5 and there are various internal applications written in VB6 and .NET. Upgraded to SQL Server 2005 about three weeks ago and since then about once a week the server throws a fit and causes all sorts of timeouts. Event Viewer is showing a bunch of same event: Event ID: 8628 Description: A time out occurred while waiting to optimize the query. Rerun the query. The events occur a rate of about 10/minute and basically lock up the server. Last time this happened I was not able to open a connection to the SQL Server to e ...Show All

• Bridgeway R

  How do i replace that character in a derived column Some rows have that character in one or more columns. If i just write this column == "" Unknown : column where the character is inside "" (can't write it here) the task will just succes without ever doing anything. The output says something like "the dataflow task had no tasks.....", which seems like a bug. Well but if the character > < is used in a replace within a dataflowtask in ssis, it automatic removes whatever flow you might have build inside that dataflow. In my opinion that seems like a bug.. if you want to do a replace in a sql task, you can't use a direct input (the sql task will then complete as if nothing was typed in ...Show All

• freestar Need help connecting java to mssql, I'm even lost at install

  Hello, Hope anyone in here can help. I have tried to install the SQL Server 5 Express, but can't seem to get it to work properly. I got a terrible name set as default for my database, as well as a terrible name for my username. I can't find a place to change this to something more manageable. It is further set to windows auth, but trying to set it to both, and trying a username (and password) always gives me a log in error. I've tried searching all over the net and in here for a simple tutorial, but can't seem to find one that helps me more than it confuses me. ***** The second part of the problem is that I have a java program which I want to connect to the database and use the tables in it, but I am at loss to how I can find what username ...Show All

• Anders Wallin Unique Constraint and Unique Index, what's the difference?

  What's the difference in the effect of the followings: CREATE UNIQUE NONCLUSTERED INDEX and ALTER TABLE dbo.titles ADD CONSTRAINT titleind UNIQUE NONCLUSTERED I found there're two settings in Indexs/Keys dialog box of the management studio, Is Unique, and Type. The DDL statements above are generated by setting Is Unique to yes plus Type to Index, and just Type to Unique Key, respectively. What's the difference between them They are both implemented using a unique index, so disregarding the meta data, there is no difference. Their usage, however, should be different. A unique constraint should be used primarily to enforce some uniqueness condition, in addition to the primary key. In other words, an alt ...Show All

• uzs1 How to restore Master DB in SQL 2005????

  I've tried starting SQL from the command line in single user mode (-m). When I try to open Management Studio I receive an error that it can't connect. Can you only restore master from a command line in SQL 2005 Or can I do it from a GUI Thanks, Mark Unfortunately the NET START "MSSQLSERVER" /m command does not work for me. However, I can add "-m" to the Startup parameters in the SQL Server service from the Services GUI and it starts in single-user mode.  I was having trouble connecting to a query window in Management Studio, when it hit me that there were still other SQL Services running.  I think that one of the other services was getting to the one connection that was available before I co ...Show All

• Bandile Cursors - Curse or blessing?

  Could someone elaborate on or describe a circumstance when a cursor could be beneficial and when using a cursor would be a bad idea Adamus Thanks Louis, This does add some clarity. However, if I might intrude a bit further... There is still a little confusion in your statement "At one time you had to resort to a cursor to do advanced manipulation of a row..." I'm lead to believe that cursors were used "at one time" simply due to a lack of better technologies. I'm not really sure what new technologies (in SQL Server 2000) have evolved, and am hoping you could portray an example of where these new advanced data manipulation techniques are now present that provide better performance and prove to be an overall better approa ...Show All

• Charlie_2163 Schedule Job Keep on failing!

  Hi, Actually i saved a SSIS package into a SQL Server 2005, then scheduled to run a job from SQL Agent, but, the job keep on failing and no error message was returned in order for me to toubleshoot. After the job failed, i restart the job again, and it actually continue to run, but unfortunately, it stopped again after some time. And, before i sheduled the job, i actually tried to run the package itself in SQL Server Business Intelligent, it runs suceessfully. In the package, i actually set the ProtectionLevel to DontSaveSensitive. Another option that I used to run the pakage was using dtexex.exe: dtexec.exe /FILE "E:\Package.dtsx" /MAXCONCURRENT " -1 " But, the error message returned also not so u ...Show All

• Chapio Error while propagating initial snapshot to subscriber (Merge Replication)

  Hi all. I get the following error when trying to run a pull subscription from the subscriber: The schema script '' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) --------------------------------------------------------------------------------------------------------------- The process could not connect to FTP site 'ftp://ESOFTSERVER.NO-IP.INFO' using port 21. (Source: ESOFT (Agent); Error number: 0) --------------------------------------------------------------------------------------------------------------- The connection with the server was reset (Source: (OS); Error number: 12031) ----------------------------------------------------------------------------------- ...Show All

• bmmsr “AcquireConnection method call to the OLEDB Connection Manager for SQL Server failed” Error

  I have an SSIS package which takes input from Flat file and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination is configured to use SQL Server Authentication for the user ‘sa’. The package works fine without enabling the configurations. But when I enable package configuration and save the configuration of the various connection managers in an XML configuration file and then run the package it gives the following error in the validation phase: [OLE DB Destination [21]] Error: The AcquireConnection method call to the connection manager "<Connection Manager Name>" failed with error code 0xC0202009. And after the validation phase is comp ...Show All

• Tomorrow Shi Dynamic FTP Connection

  Hello , I have a table having different ftp url,user name, passwod, port no.I want to copy the file from all the location on my server at. How can I change the connection string/ FTP location for FTP connection manager at rum time in SSIS. Thanks Have you set a breakpoint in the Script Task to verify that the FTP Connection Manager properties are being set to the correct values for each iteration of the loop Once you have dynamically configurated the ftp connection manager in the Script task then the FTP Task itself should have its IsRemotePathVariable set to True and then set the RemoteVariable to the variable which is mapped during the loop. ...Show All