Answer Questions

• IgnGamespy Two Questions (email from SQL & download contents)

  Hello All, Thanks in advance for any help. On the SQL Server Express 2005 download page there are two large download options: SQL Server 2005 Express Edition with Advanced Services & Microsoft SQL Server 2005 Express Edition Toolkit Is one a subset of the other Or, are both unique Just by reading it appears that the 'Toolkit' is an addition to the 'Express Edition with Advanced Services' Second question is: ...Show All

• dotcom23 what is the meaning of "64(error not found)" in sys.transmission_queue

     as Christopher Yager say in "Need distributed service broker sample", I also test sending messages between two SQL Server 2005 instances,and after I setup the test environment with instance1 and instance2,I find queue [q2] in ssb2 can't receive message from ssb1. when I query by "select * from sys.transmission_queue",I get some message records that transmission_status is "64(error not found)".  &nb ...Show All

• jeff roberts Tutorial lessons 4-10 missing

  I am going through the 2005 SQL Server Analysis Services Tutorial of which there are 10 lessons.  I get to lesson 4 and it says I need to open the "Analysis Services Tutorial - Lesson 4.sln" solution.  I can't find this on my pc, do you know where I could get this   FYI, I already installed the samples, but it is not there either. Are you using the September CTP   If so it should be in C:\ ...Show All

• atlisd Error 22029 on maint jobs

  OK this is a new error on me. I have a SQL server 2000 on Windows Server 2003. I have setup a Maint plan that backs up the user and system databases and the transaction Logs on my user databases. Does optimises and integrity checks on those databases as well. I am not attempting to repair any minor problems. I am not performing integrity checks before backing up the database and transaction logs. All of the databases that I am do ...Show All

• Tomb Linked servers and Windows Authentication

  I have seen similar questions, but none of the answers have solved my problem. I have several SQL2000 servers running under Win2003. In the past, we have been using SQL logins, but I have been trying to transition to using Windows Authentication. It has been working great except that sometimes queries using linked servers fail. The linked servers are set up for the connection to use the login's current security context. For testing this ...Show All

• Brian Rodemann Develop multiusers applications with SQL Server Express

  Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express SQL Server Express will support multiple users. To connect from other computers you must first enable "Local and remote connections" in the Surface Area ...Show All

• Sheeja Anil Sql server CONNECTION STRING...

  Hi all, I am trying to make a connection string for the SQL SERVER..in all the sites i m getting To connect to SQL Server running on a remote computer (via an IP address) oConn.Open "Provider=sqloledb;" & _ "Network Library=DBMSSOCN;" & _ "Data Source=xxx.xxx.xxx.xxx,1433;" & _ "Initial Catalog=myDatabaseName;" & _ "User ID=myUsername;" & _ "Password=myPassword" but i cant understand where should i write this in the QUERY W ...Show All

• vcspec error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20 ...Show All

• al kerr Unable to install SQL Server 2005 September CTP

  I am attempting to install SQL Server 2005.  I installed VS.NET 2005 (Beta2) on the machine previously, with SQL Express (the one that came with Beta2). I uninstalled the above using the vs_uninst.exe tool.  I was able to successfully install RC1 of VS.NET 2005, but cannot now install SQL Server 2005 Developer Edition - September CTP. I'm trying to uninstall everything and try again.  I've followed the list of components to 'unins ...Show All

• Jiang Haihong Inserting rows concurrently (paralellism)

  Hi there. I created a stored procedure that inserts rows in local server and 2 remote servers, inside a distributed transaction (emulating synchronous replication). Is there some way in T-SQL to do these 3 inserts at the same time I don’t want insert2 to begin after insert1, and insert3 after insert2. Thanks in advance No. Not if they are within the same transaction. If you want to do this ...Show All

• papaoso1 Programmatically developing an entire package..

  Hi all, I am trying to write a program that creates packages on the fly depending on the variables you pass. for eg. It should create connection managers on the fly specific to a certain file in the variable (eg. sample.csv). the package has a dataflow task and it has flat file source and oledb destination.The problem I am facing is the flat file source when assigned to a flat file connection manager(dynamically), it is not giving any source ...Show All

• Virlene Can't Connect to SQL 2005 Express Edition via Server Manangment Studio

  I have installed SQL 2005 Express Edition on a Windows 2003 Web Edition server. Everything installed correctly, no errors to be found. I also have: Local & Remote Connections using TCP/IP only turne don SQL Browser is running as well. I have tried connecting with the most recent CTP of Microsoft SQL Server Management Studio Express 9.00.1399.00 When trying to connect using the SA account I recieve: 'An error has occured while ...Show All

• alche Case - Sensitive field

  I want to specify the data in columns are both upper & lower case(i.e. one column data having all lowercase data or uppercase data ). Ex:- if i have one column - col1 and its 1st value is RAKESH JHA 2nd value is rakesh jha then how i can find that, how much row are in upper case. respectively lower case Use UPPER and LOWER functions. Like: select * from MyTable where UPPER(fCOL1)=fCOL1 Have a look at http:// ...Show All

• hsaelens Remove Numbers

  I have a column within a table with date like 25C1, 26B1, 345SS4, 432BRP5, ect........ I need the remove the numbers both front & back and leave only the letters. Like C, B, SS, BRP........... The letters will be in a new column..... Thanks If you're familiar with ODBC, you can call SQLColumns( ) on the table name, and then SQLFetch( ), SQLGetData( ) to get each column name in sequence. Then you can parse ...Show All

• Breetai7018 T-SQL Select Statement executed inside the Visual Studio 2005 Environment returns -1 for the "True" Values of the bit fields

  T-SQL Select Statement executed inside the Visual Studio 2005 Environment returns -1 for the "True" Values of the bit fields of any table. The database is SQL Server 2005. When I execute it inside the SQL Server management Studio I receieve 1 for the "true" values.   I think this is a bug. I don't have a "run selection" menu item; but, Run to cursor produces debug output that shows -1 for true values... This is de ...Show All