SQL SERVER EXPRESS 2005 FREEZE
I have a server machine running Windows Server 2003 and sqlserver express 2005 for a client-server application. All clients machines access the server thru a router fine with good response time but if the internet conecction fails suddenly the sqlserver freeze. Any sql command takes a long delay. What could be the reason ?. What [...]
Answer Question
| April 26, 2009 1:38 PM
SQL Server 2005 Express, SQL Server errors, SQL Server Express, SQL Server Express 2005
I have a server machine running Windows Server 2003 and sqlserver express 2005 for a client-server application. All clients machines access the server thru a router fine with good response time but if the internet conecction fails suddenly the sqlserver freeze. Any sql command takes a long delay. What could be the reason ?. What [...]
Answer Question
| April 26, 2009 1:38 PM
SQL Server 2005 Express, SQL Server errors, SQL Server Express, SQL Server Express 2005
.dts and .dtsx config files in SQL Server 2005
Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?
Answer Question
| April 16, 2009 9:40 AM
SQL Server 2005 Express, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS 2005
Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?
Answer Question
| April 16, 2009 9:40 AM
SQL Server 2005 Express, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS 2005
optimization of stored procedures in sqlserver
is there any stored procedure optimization techniques actually my problem is my stored procedure is getting information from 15 tables by joins and have some conditions in where clause to get 15,000 records it is taking 40 sec how can i improve the my stored procedure thanks, naresh
Answer Question
| February 10, 2011 6:15 AM
SQL Server stored procedures, Stored Procedures, Stored Procedures Optimization
is there any stored procedure optimization techniques actually my problem is my stored procedure is getting information from 15 tables by joins and have some conditions in where clause to get 15,000 records it is taking 40 sec how can i improve the my stored procedure thanks, naresh
Answer Question
| February 10, 2011 6:15 AM
SQL Server stored procedures, Stored Procedures, Stored Procedures Optimization
spool to flat file from SQL editor
I am using SQuirel SQL to execute queries against an AS400. I need to be able to execute a series of queries and export the results to a flat file on the local client. Can someone give me the idiots guide?
Answer Question
| April 17, 2009 3:13 AM
AS/400 Spooled Files, Flat files, SQL, SQL Editor
I am using SQuirel SQL to execute queries against an AS400. I need to be able to execute a series of queries and export the results to a flat file on the local client. Can someone give me the idiots guide?
Answer Question
| April 17, 2009 3:13 AM
AS/400 Spooled Files, Flat files, SQL, SQL Editor
Execute SSIS package in SQL Server 2005
how to execute SSIS package in sql server 2005
Answer Question
| April 15, 2009 11:02 AM
SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS, SSIS Package
how to execute SSIS package in sql server 2005
Answer Question
| April 15, 2009 11:02 AM
SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS, SSIS Package
Updating a field and counting unique field values from another fields all in the same query?
How can I structure the following query to allow me to count the number of unique entries in a field named “amount” and using the same query, update another field named “unique” Here is what I am doing: SQL = “select amount, count(amount) from tblmessagein group by amount having count(*) = 1″ If rsMessageIn.State = [...]
Answer Question
| April 15, 2009 10:59 AM
Query optimization, SQL, SQL Aggregate error, SQL queries
How can I structure the following query to allow me to count the number of unique entries in a field named “amount” and using the same query, update another field named “unique” Here is what I am doing: SQL = “select amount, count(amount) from tblmessagein group by amount having count(*) = 1″ If rsMessageIn.State = [...]
Answer Question
| April 15, 2009 10:59 AM
Query optimization, SQL, SQL Aggregate error, SQL queries
Looking for a query tool for SQL Server 2000 and SQL Server 2005
Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install something like this. Can [...]
Answer Question
| April 14, 2009 7:46 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server 2000, SQL Server 2005
Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install something like this. Can [...]
Answer Question
| April 14, 2009 7:46 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server 2000, SQL Server 2005
Attaching a SQL Server 2005 database to SQL Server 2000?
Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?
Answer Question
| April 14, 2009 7:22 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?
Answer Question
| April 14, 2009 7:22 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server 2005, SQL Server 2005 Database, SQL Server databases
bolding a text field
HI, I need to generate a letter, within the letter i want to ‘bold’ some of the text lines. is there a way to do that?
Answer Question
| April 21, 2009 1:28 PM
sql text
HI, I need to generate a letter, within the letter i want to ‘bold’ some of the text lines. is there a way to do that?
Answer Question
| April 21, 2009 1:28 PM
sql text
Conversion of SQL Server 2000 to iSeries DB2 V6R1
Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.
Answer Question
| October 24, 2009 7:50 PM
DB2, iSeries DB2, SQL Server 2000, SQL Server to iSeries Database, V6R1
Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.
Answer Question
| October 24, 2009 7:50 PM
DB2, iSeries DB2, SQL Server 2000, SQL Server to iSeries Database, V6R1
How to create new ramco test server?
Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.
Answer Question
| April 13, 2009 12:53 PM
ERP applications, Ramco Test Servers, SQL Server 2005, SQL Server databases
Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.
Answer Question
| April 13, 2009 12:53 PM
ERP applications, Ramco Test Servers, SQL Server 2005, SQL Server databases
SELECT statement in SAP
what are various select statements used and where are they used.what is value table.
Answer Question
| April 13, 2009 10:30 AM
ABAP, SAP ABAP, SAP development, SELECT statement
what are various select statements used and where are they used.what is value table.
Answer Question
| April 13, 2009 10:30 AM
ABAP, SAP ABAP, SAP development, SELECT statement
MSSQL Reporting services
Can a single report show more than one graph? Consider I have 4 queries to show graphs for and I’d like to have all of them in one single report, is this possible?
Answer Question
| April 13, 2009 8:34 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
Can a single report show more than one graph? Consider I have 4 queries to show graphs for and I’d like to have all of them in one single report, is this possible?
Answer Question
| April 13, 2009 8:34 AM
SQL Server Reporting Services, SSRS 2005, SSRS 2005 report formatting
Drop Database Connections
Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)
Answer Question
| April 13, 2009 8:12 AM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server databases, T-SQL
Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)
Answer Question
| April 13, 2009 8:12 AM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server databases, T-SQL
Transaction log for read only database…
Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims “when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database. Changing the database [...]
Answer Question
| May 14, 2009 2:53 AM
70-432, SQL Server 2008, SQL Server logs, SQL Server transaction logs
Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims “when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database. Changing the database [...]
Answer Question
| May 14, 2009 2:53 AM
70-432, SQL Server 2008, SQL Server logs, SQL Server transaction logs
Install SQL server client tools
With client utilities like query browser, or query analyzer…how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? Well, if we have to buy any licenses we will. [...]
Answer Question
| April 19, 2013 9:29 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server Agent
With client utilities like query browser, or query analyzer…how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? Well, if we have to buy any licenses we will. [...]
Answer Question
| April 19, 2013 9:29 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server Agent
Where to place the tempdb log file?
I’ve heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?
Answer Question
| April 13, 2009 6:11 PM
MDF, NDF, SQL Server, TempDB
I’ve heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?
Answer Question
| April 13, 2009 6:11 PM
MDF, NDF, SQL Server, TempDB
How can I correct sCaller errors in T-SQL?
How can I correct generic sCaller errors in T-SQL?
Answer Question
| April 13, 2009 6:09 PM
sCaller, sCaller Errors, SQL Server, T-SQL
How can I correct generic sCaller errors in T-SQL?
Answer Question
| April 13, 2009 6:09 PM
sCaller, sCaller Errors, SQL Server, T-SQL
Integrate MOSS with SQL Server 2008
Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question
Answer Question
| April 10, 2009 8:20 PM
MOSS, MOSS interoperability, SQL Server 2008 interoperability, SQL Server 2008 Reporting Services, SQL Server Reporting Services, SSRS, Visual Studio 2008
Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question
Answer Question
| April 10, 2009 8:20 PM
MOSS, MOSS interoperability, SQL Server 2008 interoperability, SQL Server 2008 Reporting Services, SQL Server Reporting Services, SSRS, Visual Studio 2008
VB2008 and Connection to SQL
Is there any way to connect to a SQL server using Vb2008? I’m trying to add a datasource but this allows me to conenct locally only.
Answer Question
| December 5, 2011 12:32 PM
SQL Server connectivity, VB 2008, Visual Basic, Visual Basic .NET Web services
Is there any way to connect to a SQL server using Vb2008? I’m trying to add a datasource but this allows me to conenct locally only.
Answer Question
| December 5, 2011 12:32 PM
SQL Server connectivity, VB 2008, Visual Basic, Visual Basic .NET Web services
