Answer Questions

• Somebody Error during set partner statement (SP1)

  Hi! I have the following error during setting partner on mirror server Msg 1431, Level 16, State 4, Line 1 Neither the partner nor the witness server instance for database "masterserver" is available. Reissue the command when at least one of the instances becomes available. The partner is available through telnet. I've also checked ports vai netstat and have no found errors. There are two noteworthy erros in the error log ...Show All

• Chris Richner Maintenance Plan creation fails

  I've been searching everywhere for a solution to this problem and no answers exist anywhere. When I try to create a new maintenance plan I get the following error. I've been told it may be related to SSIS but nobody has a solution. How do I fix this issue so I can create a maintenance plan. Exception has been thrown by the target of an invocation. (mscorlib) ADDITIONAL INFORMATION: An OLE DB error 0x80004005 (Client unable to establi ...Show All

• modulus Err while importing data containing value of date field is of yrs.1800

  hi Dear All How can i import data in SQL Server 2000 which contains the value of date field from 1800 yrs to till now eg. 15/12/1860, 10/10/1896, 10/10/2006 but if i change the year of date value to 19 then it's imported. anybody can help me please! Thanks in advance Rahman Are you trying to use a smalldatetime field to store the data ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/htm ...Show All

• DerikMHinz Sql 2005 Express and Sharepoint

  Can I use SQL 2005 Express for Sharepoint rather than the MSDE that comes with SharePoint   If so, what is the installation procedure Will you be able to search WSS with the sql 2005 express Also, what is the file size limit Windows SharePoint Services does support running on SQL Express, but before you upgrade you should consider that SQL Express has a file size limit ...Show All

• Marco Wiedemeyer Lost tables and Stored Procedures after installing SP!

  I installed SQL 2005 SP1. After the installation I cannot display tables that were created with SQL2005. Tables that were created with SQL2000 still display. Updates to the SQL2000 tables do not display. The Stored Procedures that were created using SQL2005 do not display. This is true of the original .mdf file as well as backup files. I uninstalled SQL2005 and re-installed it. No change. The file size is the same as the backups so I think the d ...Show All

• www.GaaLive.com “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 t ...Show All

• Filip Stanek Execution ID

  Hi , For how long is the value of Execution ID valid Is it valid after the session also Can i store the value of Execution ID in some place and use it after some time/day to get the last excution done on the report Thanks   Please tell me if it is really to write correct web tests with using parameters Execution ID and Control ID for a long using. (for using this tests for a month or two). An ...Show All

• fargs SQL Cluster Servers

  We currently have a Compaq MA8000 SAN with no useable LUN's available. We have purchased a HP XP12000 with 5TB of useable drive space. I would like opinions on the best way to move our SQL Cluster Servers and Databases that equal about 3TB of Drive Space. We will be connecting the Cluster servers to both SAN's using a dual HBA. We only have 3 days to move the data and the clusters over to the new SAN. We must be operational by Tuesday Morni ...Show All

• Brave Daun Passing parameter using .SQL

  Hi all I need to pass parameters when I call a .SQL file. Is there a way to do this in SQL Server thanks!!!! There is no easy way to pass parameters from a batch script and reference it in a SQL script in SQL Server 2000. So you will have to use a different utility to pre-process the SQL script based on the parameter value and then pass it to OSQL. In SQL Server 2005, you can use the new SQLCMD command-line utility which has some pre ...Show All

• gphillipk Report task?

  Hello, I'm not sure if this one should be in this forum. Anyway... I need to build some reports in MS Word format. Is there are any way to do that It can probably can be done in Reporting Services, but how I can merge these two tools in one project (solution) for example Thanks. Ok... Thanks. Last question. How I can include report part in SSIS package itself So the report can be executed on package flow. ...Show All

• n.shah12 Restoring just a table from a full backup

  is there a way to restore certain tables from a full backup I am not sure. We are using Great Plains 9 and my bose told me he just wants to backup and restore payroll. When you use for example SQL LiteSpeed for dumping (also usefull for quick and compressed dumping) there is an option in the admin tool for SQL LiteSpeed where you can restore a single object (view, sp, table, ...Show All

• sam8sam JDBC Driver 2005 exception stack trace

  Hi, I had some Java code that worked fine using SQL Server 2000 but does not work using SQL Server EXpress 2005. I tried working the JDBC driver for 2005. I got the following excpetion: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'master.dbo.spt_datatype_info'.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
 at com.microsoft.sqlserver.jdbc.IOBuffer.processP ...Show All

• chantit Cannot import file from Mainframe

  Hello Everybody! Im trying to migrate my SQL 2000 packages that’s currently working in the company production enviroment to SSIS packages. So, in the 2000 version i got the flat file from Mainframe and i had to do a trick to transform all the columns to match the same size as the example above: 1432 1138734217 1144256628<CRLF> 1432 1138734217<CRLF> 1433 1136657788 1122441177<CRLF> 1433 1125554545 1122441177<CRLF> 1 ...Show All

• DGaddy dynamically switching databases in a script

  I've got a situation where I need to execute portions of a script against every database on a given instance. I don't know the name of all the databases beforehand so I need to scroll through them all and call the "use" command appropriately. I need the correct syntax, the following won't work: DECLARE DBS CURSOR FOR SELECT dbname FROM #helpdb ORDER BY dbname OPEN DBS FETCH NEXT FROM DBS INTO @dbname WHILE @@FETCH_STAT ...Show All

• RON 7659 Execution of queries on tables without table owner specified fails.

  Hi Having some issues with our apps. We are trying to get our applications to work with sql2005. Ive got the databases "setup", and all our apps run fine... ...except for when queries are made without the owner of the table being specified in the query. The connection is opened with the username that is associated with that owner. And it fails in Manager as well. Is there something im missing, because you should be able to do this. ...Show All