Answer Questions

• Pabs Failed to generate a user instance of SQL Server

  I am trying to create an SQLExpress database file (mdf) in VS2005 but I get the following error: "Failed to generate a user instance of SQL Server due to a failure in making a connection to the user interface. The connection will be closed.” I also get this same error if I try to open an existing database from the VS samples. Any Ideas Thanks, Dave T I have the same problem. I installed SQL 2005 Server, I do ...Show All

• JohannHough import from binary file

  I am importing data from binary data files into SQL Server. This is the code I am using: Do While Not EOF(1) Get #1, , NonStdCurrRecord adoRS.AddNew adoRS!Field1 = CDate(NonStdCurrRecord.Field1) adoRS!Field2 = CSng(NonStdCurrRecord.Field2) adoRS!Field3 = CSng(NonStdCurrRecord.Field3) adoRS!Field4 = CSng(NonStdCurrRecord.Field4) adoRS!Field5 = CSng(NonStdCurrRecord.Field5) adoRS!Field6 = CSng(NonStdCurrRecord.Field6) adoRS!F ...Show All

• Andreas Holthaus SMO BulkCopy

  We have a SQLServer 2000 stored procedure, which imports data from files using SQL-DMO BulkCopy object(sp_OACreate are used to create objects). We also use Format files to aide the import. Now, we are planning to convert this stored procedure to .NET application using Visual Studio 2005. Books Online says I have to use SMO Transfer object. But I could not find any information/examples how to BulkCopy using this object. Any guidance in this ...Show All

• phita Queries returning Multiple instances of the same record

  I am running SQL 2005 and have created a simple database for interfacing with Visual Web Dev 2005 and Visual Studio 2005. I noticed that my applications where returning multiple instances of the same records in the queries. I went back to the SQL server and created a query, and sure enough, I'm getting each record returned 3 times. Where do I start to resolve this issue DId you have the records already duplicated in the database tables Or ...Show All

• Gerard van de Ven how to add a nvarchar parameter to ntext or text types?

  please help >> how to add a nvarchar parameter to ntext or text types like : set @ntext_param = @ntext_param + @nvarchar_param Concatenation is not supported on ntext, but is supported on nvarchar(max). You can do the following: set @ntext_param = convert(nvarchar(max), @ntext_param) + @nvarchar_param You cannot declare variables of text/ntext/image data type in SQL Server and ...Show All

• Hitesh193 Clearing cache

  Is it possible to clear cache without restarting the SSAS service . In AS2000 It was done by using the flushcache vbscript sample, but I didnt find a method similar to suspend/resume one, in AMO or xmla syntaxis. Thanks Leandro You might find the 'ascmd' utility useful. It includes a sample for clearing the cache. The utility is part of the April 2006 updated Samples under Analysis Services \ Administration Download here: ...Show All

• Recrehal Can't install SQL Server 2005 Standard -- beta versions detected

  =============================================== UNACCEPTABLLY POOR UNINSTALL AND INSTALL ROUTINES !!! =============================================== These routines should be unstoppable!  How can we sell if we can't install!  I can't get the SQL Server 2005 Standard Edition to load after I have removed SQL Server 2005 Developer Edition CTP (June).  I have been using the Beta 2 for a few months. I have used the uni ...Show All

• mep_fuso Small Business Accounting

  Using Small Business Accounting with SQL Server 2000 sp4. Tried updating SQL Server to 2005 and updating the instance name for Small Business Accounting but received an sql time out error when starting SBA. Any suggestions how to update correctly. When I installed sql server 2005 some how my (local)\microsoftsmlbz sql server was no longer registered.  Since I did not know the username or password to reregi ...Show All

• Pedro Bernardo How to script an excel datasource in sql job? (SSIS)The command line parameters are invalid.

  I have a Sql agent job which will exeute a SSIS package.  While, one of my data sources is an excel file. I scriptted the sql agent job and recreate on a test server, it fails with The command line parameters are invalid. . The command line has the following for the excel data source, and that is the place fails the job. /CONNECTION UserDataExcel;"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\myserver\UserData\UserData.xls ...Show All

• Mr Bruce Help regarding db and tool selection

  hi we want to develop an application regarding notices issued from different departments of the company. These notices may be in the form pdf, doc, ppt etc  files. we want to store these files in database and finally we want to search these documents on the basis of text having these documents. can plz anybody help me in finalizing which database and front end tool is best for this type of application. thanks in advance Nasir Jave ...Show All

• donnie100 SQL Srvr 2005 DTS

  Hi, I need help in creating a DTS in SQL Srvr 2005, can anybody help me doing this please   AC Hi Wesley, thanks very much, so if I don't have the visual studio 2005 in my programs, it means that I dont have a version that support this feature, correct   Thanks and regards. AC Thanks very much. AC AFAIK it is indeed only supported in Standard and Enterprise, not Express.  You can connec ...Show All

• mgaur_MSFT a generic error occurred in gdi+

  I'm receiving "a generic error occurred in gdi+" processing error while running a preview of my report inside visual studio. When this report is opened by a client, their browser will just hang (Not Responding). Other reports don't have error. The report will not render any chart although thousands of record will be need to output. Hope anyone can help. Thanks! Brian, Thanks for your response. ...Show All

• Valkyrie-MT Errors not logged

  Hi : I have created the followign ddl trigger to log all the ddl activities. It is workign fine for all the sucessfully created objects. The problem is, how do i log errors also. Like if i am trying to create a table with same name twice then the trigger should log a stmt saying that the table already exists in the database. or while creating synonyms twice with same name, etc I want to log all the failed DDL stmts also. Any solutio ...Show All

• Sriram Krishnan MSFT MAIL on SQL Server 2000 Standard on Windows Server 2003 64-bit

  I've read about 2005 Enterprise Edition 64-bit and 2000 Enterprise Edition 64-bit and those mail issues. But, my particular situation is running SQL Server 2000 Standard Edition (32-bit) on Windows 2003 Server (64-bit). I got the mail profile set up ok for the SQL Server Service Account using Outlook 2000 and can send and receive mail using Outlook. But, even after restarting the SQL Server Services, there's no profile to choose in the SQ ...Show All

• Stephen_Weber Replication distribution cleanup error

  I used the SQL Server 2005 publication wizard to set up transactional replication. It scheduled a job called "Distribution clean up: distribution" that calls sp_MSdistribution_cleanup. The job fails every time it runs. The xp_cmdshell is enabled and SQL Server Agent runs under an account that has sufficient privileges to execute it. The account also has full rights to the repldata subdirectories. I have applied service pack 1. I loo ...Show All