Migrating data from a SQL Server 2005 database to SQL Server 2000
I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical [...]
Answer Question
| January 27, 2009 7:52 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Migration, SQL Server migration
I am looking for advice on what technology to use to migrate data from a SQL Server 2005 database to SQL Server 2000. We are currently phasing out our old help desk ticketing system in SQL Server 2005 to a new ticketing system in SQL Server 2000. The tables in the databases are not identical [...]
Answer Question
| January 27, 2009 7:52 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server Database Migration, SQL Server migration
Pulling rows from SQL Server and loading the data into column textboxes
I am trying to load data into 13 column textboxes, and I need the ability to pull any number of rows from the SQL Server based on these parameters: control group number, accounting period and posting date. The results will be about 50 lines of transactions, and I want those loaded to textboxes on my [...]
Answer Question
| January 27, 2009 7:49 PM
SQL Server, SQL Server database, SQL Server database design and modeling, SQL Server Row Versioning
I am trying to load data into 13 column textboxes, and I need the ability to pull any number of rows from the SQL Server based on these parameters: control group number, accounting period and posting date. The results will be about 50 lines of transactions, and I want those loaded to textboxes on my [...]
Answer Question
| January 27, 2009 7:49 PM
SQL Server, SQL Server database, SQL Server database design and modeling, SQL Server Row Versioning
Shortening the generation time for a SQL Server 2000 report
I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?
Answer Question
| January 27, 2009 7:43 PM
Microsoft Excel, SQL Server 2000, SQL Server performance, SQL Server Reports
I have 516 different functions in SQL Server 2000 that are used for different calculations. These functions will operate on more than a thousand Microsoft Excel files. Each Excel file has 960 rows, and generating the report took over four hours. Is there a way to shorten this?
Answer Question
| January 27, 2009 7:43 PM
Microsoft Excel, SQL Server 2000, SQL Server performance, SQL Server Reports
Transferring a database and writing a database script in SQL Server 2008
I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?
Answer Question
| January 26, 2009 3:09 PM
SQL Server 2008, SQL Server Database Migration, SQL Server databases
I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?
Answer Question
| January 26, 2009 3:09 PM
SQL Server 2008, SQL Server Database Migration, SQL Server databases
SQL Server 2005 Memory
SQL server 2005 running on windows XP, memory grows steadily then SQL(system) hangs when memory gets to 1.7 gb…Server must be re-started. What could cause this?
Answer Question
| January 29, 2009 1:22 PM
SQL Server 2005, SQL Server memory, SQL Server performance, SQL Server performance tuning, Windows XP
SQL server 2005 running on windows XP, memory grows steadily then SQL(system) hangs when memory gets to 1.7 gb…Server must be re-started. What could cause this?
Answer Question
| January 29, 2009 1:22 PM
SQL Server 2005, SQL Server memory, SQL Server performance, SQL Server performance tuning, Windows XP
Field data in Footer SSRS 2005
I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.
Answer Question
| March 26, 2009 10:37 PM
Reporting Services 2005, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2005 header and footer, SSRS 2005 report formatting
I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.
Answer Question
| March 26, 2009 10:37 PM
Reporting Services 2005, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2005 header and footer, SSRS 2005 report formatting
Acquiring the AdventureWorks database for SQL Server 2005
How can I get the AdventureWorks database for SQL Server 2005 SP1?
Answer Question
| January 25, 2009 8:30 PM
AdventureWorks, AdventureWorksDW, SQL Server 2005, SQL Server databases
How can I get the AdventureWorks database for SQL Server 2005 SP1?
Answer Question
| January 25, 2009 8:30 PM
AdventureWorks, AdventureWorksDW, SQL Server 2005, SQL Server databases
Using indexes in SQL Server 2005
What is the main purpose of using indexes in SQL Server 2005?
Answer Question
| August 21, 2009 8:29 PM
SQL Server 2005, SQL Server index strategy, SQL Server Indexes
What is the main purpose of using indexes in SQL Server 2005?
Answer Question
| August 21, 2009 8:29 PM
SQL Server 2005, SQL Server index strategy, SQL Server Indexes
Problem rendering a field in SQL Server Reporting Services
I have a strange problem with SQL Server Reporting Services. My report does not render a field when viewed either from Report Manager or when run through subscription. However, the same field is rendered correctly when I test the report in Development Studio. Why might this be?
Answer Question
| January 25, 2009 8:28 PM
SQL Server Development Studio, SQL Server Reporting Services, SSRS Errors
I have a strange problem with SQL Server Reporting Services. My report does not render a field when viewed either from Report Manager or when run through subscription. However, the same field is rendered correctly when I test the report in Development Studio. Why might this be?
Answer Question
| January 25, 2009 8:28 PM
SQL Server Development Studio, SQL Server Reporting Services, SSRS Errors
Different SQL Versions on the same server.
I was hoping someone could tell me if its ok to install SQL2008 Standard for use with company accounting and billing applications and also install SQL2008 Express for use with Sharepoint 3.0 on the same server. I could put the versions of SQL on different volumes if that helps. The load Sharepoint puts on the [...]
Answer Question
| January 25, 2009 3:15 PM
Multiple SQL Server Installations, SQL Server 2000, SQL Server 2000 Standard Edition, SQL Server 2008
I was hoping someone could tell me if its ok to install SQL2008 Standard for use with company accounting and billing applications and also install SQL2008 Express for use with Sharepoint 3.0 on the same server. I could put the versions of SQL on different volumes if that helps. The load Sharepoint puts on the [...]
Answer Question
| January 25, 2009 3:15 PM
Multiple SQL Server Installations, SQL Server 2000, SQL Server 2000 Standard Edition, SQL Server 2008
Linked Server Question
I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when I try to access it, I [...]
Answer Question
| January 23, 2009 2:02 PM
Access 2003, Linked Server, Linking Access and SQL Server, Microsoft Access, SQL Server 2005
I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when I try to access it, I [...]
Answer Question
| January 23, 2009 2:02 PM
Access 2003, Linked Server, Linking Access and SQL Server, Microsoft Access, SQL Server 2005
SQL SERVER 2000, 2005 & 2008
Can Sql Server 2000/2005/2008 exist on the same machine
Answer Question
| January 23, 2009 4:15 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server upgrades
Can Sql Server 2000/2005/2008 exist on the same machine
Answer Question
| January 23, 2009 4:15 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server upgrades
SQLCODE and SQLSTAT error messages?
Does anyone know where I can find SQLCODE and SQLSTAT error numbers and messages?
Answer Question
| February 19, 2009 2:27 PM
SQL error messages, SQLCODES, SQLSTAT
Does anyone know where I can find SQLCODE and SQLSTAT error numbers and messages?
Answer Question
| February 19, 2009 2:27 PM
SQL error messages, SQLCODES, SQLSTAT
Investigating SQL Server 2005 memory issues
We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we’re seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates greatly, but a [...]
Answer Question
| January 22, 2009 6:27 PM
SQL Server 2005, SQL Server memory
We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we’re seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates greatly, but a [...]
Answer Question
| January 22, 2009 6:27 PM
SQL Server 2005, SQL Server memory
Transposing a table using SQL Server Reporting Services in VB.NET
How can I transpose a table using SQL Server Reporting Services in VB.NET?
Answer Question
| January 21, 2009 6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, VB.NET
How can I transpose a table using SQL Server Reporting Services in VB.NET?
Answer Question
| January 21, 2009 6:18 PM
SQL Server Reporting Services, SQL Server tables, SSRS, SSRS Table Transposing, VB.NET
Storing large data files in SQL Server
What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?
Answer Question
| January 22, 2009 6:13 PM
SQL Server 2005, SQL Server 2008, SQL Server Data Storage, SQL Server Database Consolidation
What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?
Answer Question
| January 22, 2009 6:13 PM
SQL Server 2005, SQL Server 2008, SQL Server Data Storage, SQL Server Database Consolidation
Error uploading records into a SQL Server table
We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?
Answer Question
| January 22, 2009 6:07 PM
SQL Server errors, SQL Server tables
We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?
Answer Question
| January 22, 2009 6:07 PM
SQL Server errors, SQL Server tables
Recovery models for SQL Server databases
What are acceptable recovery models for the Master and MSDB databases?
Answer Question
| January 22, 2009 6:03 PM
SQL Server backup and restore, SQL Server Database Recovery Models, SQL Server databases, SQL Server Master Database, SQL Server MSDB Database, SQL Server recovery
What are acceptable recovery models for the Master and MSDB databases?
Answer Question
| January 22, 2009 6:03 PM
SQL Server backup and restore, SQL Server Database Recovery Models, SQL Server databases, SQL Server Master Database, SQL Server MSDB Database, SQL Server recovery
An alternative to using triggers on a SQL Server
I am using triggers to update two similar tables on a SQL Server. Is there any other method to do this?
Answer Question
| January 22, 2009 5:59 PM
SQL Server tables, SQL Server triggers
I am using triggers to update two similar tables on a SQL Server. Is there any other method to do this?
Answer Question
| January 22, 2009 5:59 PM
SQL Server tables, SQL Server triggers
Building reports in SQL Server 2008
I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?
Answer Question
| January 22, 2009 5:54 PM
SQL Server 2008, SQL Server reporting, SQL Server Reports
I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?
Answer Question
| January 22, 2009 5:54 PM
SQL Server 2008, SQL Server reporting, SQL Server Reports
