Query Manager Error
Type SQL Statement ************************** Beginning of Data ************************* 0001.00 SET MISC :MISC6 0002.00 SELECT bcbgcd COLHDG(“MISC” “CODE”), 0008.00 &MISC LEN(4,0) COLHDG(“SHARED CONTAINER” “CODE”) NAME(MISC) 0009.00 FROM lmbcrela 0012.00 WHERE bcbgcd=&MISC In checking the SQL syntax it errors: Token MISC was not valid. Valid tokens: :.

Answer Question   |  September 16, 2010  4:42 PM
AS/400, SQL Query, SQL Server, V5R4M0

Process ID 174:102 owns resources that are blocking processes on Scheduler 2.
Looking for solution to Process ID 174:102 owns resources that are blocking processes on Scheduler 2. We recently installed our Lucent Vitalnet app with SQL 2000.  it runs fine for 2-3 days, then the app stops when the above SQL error message occurs.  Rebooting the server temporarily fixes the problem until another 2 days. Also [...]

Answer Question   |  September 10, 2010  4:15 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Server 2005, SQL Server upgrades, Windows, Windows Server, Windows Server 2003, Windows Server 2003 SP2

Trouble installing SQL Server 2005
I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

Answer Question   |  September 9, 2010  8:06 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Installation, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 administration

Can I restore a SQL 2000 backup to a new SQL Server 2005?
Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

Answer Question   |  September 8, 2010  8:32 PM
SQL 2000, SQL migration, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server migration, Windows Server 2008

Upgrading from SQL 2000 to SQL 2005
Will you need to purchase a new server to upgrade SQL 2005?

Answer Question   |  September 8, 2010  3:23 PM
SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server Hardware

How do I use primary keys in SQL server?
I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i use course_id?  

Answer Question   |  September 9, 2010  7:03 AM
Primary keys, SQL, SQL Server, SQL tables

SQL Express 2005 query times lagging
I execute some simple queries on my own system’s sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server’s sql server express 2005, the queries execution time is about 3 seconds or more and I don’t know why. both of the systems have the [...]

Answer Question   |  September 15, 2010  7:40 AM
SQL Express 2005, SQL queries, SQL Server, SQL Server performance, SQL Server Query

XML Schema Problem
hi I have an xml file <UserRoleConsumers> <UserRoleConsumer> <ConsumerID>67</ConsumerID> <RoleConsumerID>89</RoleConsumerID> </UserRoleConsumer> <UserRoleConsumer> <ConsumerID>45</ConsumerID> <RoleConsumerID>78</RoleConsumerID> </UserRoleConsumer> … …. … </UserRoleConsumers> while creating a schema for this CREATE XML SCHEMA COLLECTION UserRoleConsumerSchema AS ‘ <schema xmlns=”http://www.w3.org/2001/XMLSchema”> <element name=”UserRoleConsumers”> <complexType> <element name=”UserRoleConsumer”> <complexType> <sequence> <element name=”ConsumerID” minOccurs=”1″ maxOccurs=”1″ /> <element name=”RoleConsumerID” minOccurs=”1″ maxOccurs=”1″ /> </sequence> </complexType> </element> </complexType> [...]

Answer Question   |  September 3, 2010  10:37 AM
SQL, SQL Server, SQL Server 2008, XML and XML schema, XML File Creation

Parameter Date Conversion in SQL 2000
my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand to put date in DD/MM/YYYY format. 

Answer Question   |  September 3, 2010  4:22 PM
C#, SQL, SQL 2000, SQL commands, SQL Parameters, SQL Server, String manipulation, Visual Studio 2005

SQL Insert Error Against Runtime Control Error in FLP
am trying to insert into sql-2000 database my code is: StringBuilder sb=null; sb=new StringBuilders; sb.Append("Insert into dummy(name,amount) values"); foreach(Control ctl in this.FlowLayoutPanel1.Controls) { if( ctls.Name.Contains("tb") && ctl is TextBox) { sb.Append(ctl.Text); } } foreach(Control bbl in this.FlowLayoutPanel1.Controls) { if (bbl.Name.Contians("bb") && bb is TextBoxe) { sb.Append(bbl.Text); } } SqlCommand cmd=new SqlCommand(sb.ToString(),con); cmd.CommandType=CommandType.Text; cmd.ExecuteNoneQuery(); I don’t [...]

Answer Question   |  September 3, 2010  6:55 AM
C#, SQL 2000, SQL error messages, SQL Server, SQL Server 2000

Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?
What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

Answer Question   |  November 3, 2010  8:14 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration

SQL Server 2005 error after development
I developed an application and when we moved it to the clients site we started getting this error from their SQL 2005 box: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server [...]

Answer Question   |  September 2, 2010  8:12 PM
Application deployment, Application development, SQL Server, SQL Server 2005

SSRS Dynamic Report Parms
I am desiging a report to use several parameters. The first parm is report type. I need the other parameters to show or hide depending on the selection made to the first parameter. Can anyone help? Thanks

Answer Question   |  September 1, 2010  4:14 PM
SQL, SQL Parameters, SQL Server, SQL Server 2008, SSRS, SSRS reports

When creating a web application in Sharepoint 2007, where is the data stored?
hello guys when I create a web application on sharepoint 2007…where does t he data and documents that am uploading be saved?? in that path that I have set ?? or on SQL Server that I have installed on C: drive thank u in advance

Answer Question   |  September 11, 2010  7:29 AM
Data storage, Data storage management, SharePoint 2007, SharePoint Server, SharePoint Server 2007, SQL Database

Is it possible to install SQL Server 2008 R2 on Windows 7 Home Basic 64 bit?
Hi, Is it possible to install MS SQL SERVER 2008 R2 INSTALLATION ON WIN 7 HOME BASIC 64 BIT OS.  

Answer Question   |  September 1, 2010  7:07 AM
SQL Server, SQL Server 2008, SQL Server 2008 R2, Windows 7, Windows 7 64-bit, Windows 7 Home Basic, Windows 7 in 2010

Connect JasperServer and Sql 2008
i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib # Restart JasperServer (there is a shortcut in the start menu to [...]

Answer Question   |  September 1, 2010  4:03 AM
Jasper, JasperServer, JDBC, SQL, SQL 2008, SQL Server 2008, SQL Testing

SQL 2008 R2 CPU Count
The SQL 2008 R2 Std specification says it can use up to 4 cpus.  If I have two quad-core xeon processors.  Would this count as 8 or 2?

Answer Question   |  September 2, 2010  5:55 PM
CPU usage, Intel Xeon, SQL 2008, SQL Server 2008, SQL Server 2008 R2

ADO not receiving errors raised in sub procedure
Hi, I’v known for a while that ado has it’s limits when it comes to dealing with errors… but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that [...]

Answer Question   |  September 16, 2010  11:42 AM
ActiveX, ActiveX Data Objects, ADO, ASP, SQL Server 2008, Stored Procedures, VBScript

Sharepoint 2010 x64 central administration problem http error:503. The service is unavible
Hi. I installed Sharepoint 2010 x 64 version. My sql server is Sqlserver 2005 + Sp3+ hotfix. I confingured sharepoint central administration with NTLM. When i tryed open central administration it gives me Service Unavailable   HTTP Error 503> the service is Unavailable . My operating System is windows 2008 server enterprise edition x 64 I did [...]

Answer Question   |  August 1, 2011  8:13 AM
Sharepoint 2010, SharePoint 2010 deployment, SQL Server 2005 SP3, VMware ESX 4.0, Windows Server 2008 Enterprise x64 Edition

Updating database index
when i create a table with nearly 100 rows, database index gets update to accomodate those 100 rows. Can i find out the time taken by the index to get updated from previous state to a state to accomodate those 100 rows?

Answer Question   |  August 31, 2010  7:18 AM
Database, Database index strategy, Database management, Indexing, SQL Database Indexing