Answer Questions

• __Jim__ SQL Mobile Query

    On the paper: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp frame=true While trying to complete the exercise, I encountered the following unexpected behaviour: While configuring the subscription for the SQL Mobile (from the tutorial – To complete the subscription) section, I encountered the following error – TITLE: Microsoft SQL Server Management Studio ------------- ...Show All

• StuUK Combine Data and Split into separate txt files for each header/detail row groupings

  I’ve created with the help of some great people an SSIS 2005 package which does the follow so far:   1)        Takes an incoming txt file.   Example txt file: http://www.webfound.net/split.txt       The txt file going from top to bottom is sort of grouped like this      Header Row (designated by ‘HD’)       & ...Show All

• Ian Espiga SQLIOStress and SQL Server 2005

  Hi, I came across this tool recently and was wondering whether MS recommends its use to stress test I/O operations for SQL Server 2005 (64-bit) The following link http://support.microsoft.com/ id=231619   (applies to SQL Server 7 and 2000 ) mentions that: " SQLIOStress creates separate data and log files to simulate the I/O patterns that SQL Server will generate to its data file (.mdf) and its log file (.ldf). SQLIOStress do ...Show All

• Oaktreewood SQL 2000 --> SQL Express via 2000 DTS

  I know this probably shouldn't work. I've created a DTS package using SQL 2000 Export Wizard, exporting all tables from a SQL 2000 database into a SQL 2005 Express. I'm able to pick the SQL 2000 database, and the 2005 Express database using the wizard, but when the job runs I get the error: [SQL-DMO] You must use SQL Server 2005 management tools to connect to this server. Any ideas I've installed the SQL 2005 Backward compatibility pack, but ...Show All

• hitesh How do I check whether the Sql Server is installed or not in the particular machine in a network?

  How do I check whether the Sql Server is installed in the particular machine in a network within the same domain Suppose If i got a machine name as c-4200 in a network I need to display the all the database instances it has How do i do that Hi, there is an easySMo way: ServerConnection srvConnection = new ServerConnection ( "MyServer" , "myUser" , "mypassword" ); Serve ...Show All

• Cadey In VB Express 2005, I cant save any record in database of sql server.

  I was using the msdn tutorial regarding sql database for vb2005 express. In that tutorial, I followed the steps as listed. But the problem is that the save button in my application during run time, it does not work. Furthermore, the code for for saving a record during run time does not work as well. I have reinstall sql 2005 server and vb2005 express but of no use. I have winxp with system of pentium 4. What I should do to solve this di ...Show All

• Tom Atchison Keyboard shortcuts for most common tasks

  Hi There! Is there and keyboard shortcuts for common tasks like opening a table in Object Explorer, or designing a table from object explorer Is the only way that you can do it with the keyboard is by pressing Shift+F10 and then select it from the menu     ...Show All

• CougarT Volatile parent key

  I get this message every time i start Server Management Studio Express CTP, i have lates download ie 11/11/2005 V2. Can not create a stable subkey under volatile parent key. I click continue and Server Management Studio Express CTP seem to start OK. Can you help with this. I had the same problem fresh after installing SQL Server Management I loaded it and got that annoying Volatile parent key message with no ot ...Show All

• Scott S. Waschitz AS2005 September CTP Memory Error

  I get "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed." while executing query set with cube browser in SQL Server BI Dev Studio. The same error I get while executing query with VB code (via ADOMD). The source of the error is AS2005 OLEDB Provider. One important information: I have installed Sept CTP on clean Windows XP Pro, there were no previous ...Show All

• Petr Melichar VS2005 YES! Management Studio NO ...

  I have a machine running Windows Server 2003 x64. It has VS2003 running on it and VS2005. in VS2003 I can connect fine to a SQL Server 2000 database running on another machine on my network. If I launch SQL Server Management Studio, I cannot connect to it.  Generally, the error is a timeout. The VS2003 credentials seem to be much the same as the ones I enter for Management studio (Integrated security, same name, same database). The one I'm ...Show All

• jadams Conditional Container

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• davecarrera transfer a sheet from excel in to sql table

  I would like to transfer all the cells of an excel sheet to a temp table in such a way that there is no data loss and no rows of columns of data are made to Null or omitted. take a example. Tanks ...Show All

• Ivan Arjentinski Raw File Destination Create Always error

  Hello, I'm having issues with the Raw File Destination and using Create Once/Create Always. First problem we have is that if we have WriteOption="Create Once" when the file is already present then we get a design-time validation error: "Error occurred because the output file already exists and the WriteOption is set to Create Once". To me that doesn't seem right - why should the fact that the file already exists be a problem - it doesn't matter ...Show All

• dotnetprogram Using SQL Server 2005 Express in a Windows peer-to-peer workgroup

  Does anyone have a experience or links to resources for implimenting SQL Server 2005 Express in a Windows peer-to-peer workgroup Thanks. I'm going to move this thread to the new SQL Express forum. I think they might be able to answer you. -Jeffrey I don't have any specific documentation on this, do you have a specific question I'd be interested to hear if others on the forum have any experience d ...Show All

• GavinLaz SQL Express license hosting for business purpose?

  Hi every one, SQL Server 2005 Express License allow hosting for business purpose, as DB size is limited to 4 GB Any restriction or limitation regards Yes, SQL Server Express limits Reporting Services data sources to local, relational data sources only. This limitation is in SQL Server 2005 Express and SQL Server 2005 Workgroup. SQL Server 2005 Standard and Enterprise Edition do not restrict data sources for Reportin ...Show All