Error message when restoring a SQL Server database
This error received when restoring a SQL Server database: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database.

Answer Question   |  August 4, 2011  7:16 PM
SQL Server backup and restore, SQL Server database, SQL Server error messages, SQL Server restore

Trouble backing up our SQL Server transaction logs
Our SQL Server transaction logs have not been backing up, and I discovered it’s because a database was not selected in the maintenance plan. When I select the database and save it, however, it is not saving. It keeps reverting back to the previous option. Does anyone know why?

Answer Question   |  February 10, 2009  7:13 PM
SQL Server backup, SQL Server backup and restore, SQL Server transaction logs

SQL+ running time error
Can anyone let me know I have a problem to run SQL that after runing sql_build_tables.sql why c:sql_build_tables.txt is empty (0 byt)- this use Win XP to run However, when I use Vista to run the SQL show Cannot create SPOOL file “c:sql_build_tables.txt” as show below OBJECT_TYPE COUNT(*) ————————————– ——— SEQUENCE 5 TRIGGER 2 TABLE [...]

Answer Question   |  February 9, 2009  6:27 PM
SQL, SQL error messages, SQL Plus, Windows XP

Fill factor on subscriber
Hello, We have an OLTP application for which a majority of the database’s tables are replicated between two environments. The publisher side is intended to handle the writes from users and the subscriber handles the reporting aspect of the application. The subscriber therefore is mainly read by users and should only be updated by replication. [...]

Answer Question   |  February 6, 2009  4:17 PM
OLAP/OLTP, SQL Server Indexes, SQL Server replication

Creating DTS package for Linked Server database
There is a linked server database for which packages are to be created using DTS wizard. Please can anybody help me by telling how to create packages. Thanks

Answer Question   |  February 6, 2009  3:53 AM
DTS Import/Export Wizard, DTS package, Linked Server database, Linked servers

Performance of very large SQL Server table with millions of rows
Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it [...]

Answer Question   |  February 6, 2009  12:57 AM
Database design, SQL Server administration, SQL Server database design and modeling, SQL Server maintenance, SQL Server performance, Very Large Databases

SQL Server Query Help Needed
I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I’m trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the Inventory Transaction table to the Shipment (Sales Order) tables [...]

Answer Question   |  February 6, 2009  10:39 PM
INNER JOIN, JOIN statement, LEFT JOIN, RIGHT JOIN, SQL, SQL queries, SQL Query, SQL Server development, SQL Server Query

Address segregation in SQL 2005
I am working in SQL 2005 and would like to parse an address filed such as “1234 N CLARK ST APT 111 ” into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

Answer Question   |  February 6, 2009  8:30 PM
SQL, SQL 2005, SQL Address Segregation

Why does my SQL Trigger malfunction?
I have the following code installed on my database. Create Trigger CFXSOUpdate On SalesOrder For Update AS If Update(SOM_DefaultRequiredDate) or Update(SOM_DefaultShipMethod) Declare @Body varchar (100) Set @Body= ‘The Required Date or Ship Method has been changed’ Exec master..xp_sendmail @recipients = ‘ARaedeke@Tri-Optic.com’, @subject = ‘Sales Order Change’, @message = ‘@Body’ The trigger fires when the fields [...]

Answer Question   |  February 17, 2009  6:43 PM
SQL Server, SQL Trigger

Why isn’t my data displaying in the next page of Gridview?
I added a sqldatasource from my toolbox to my aspx page. I then configured the sqldatasource to connect to a table. I then added a gridview to the same aspx page and selected the sqldatasource as it’s data source. In addition to other column formatting etc., I set paging to true. I then opened the [...]

Answer Question   |  July 21, 2009  5:25 PM
ASPX, GridView, SQL data source, VBScript, Visual Studio, Visual Studio 2005

To retrieve records from SQL Server database
Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named “Name” in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on…. Now, through some application [...]

Answer Question   |  February 10, 2009  3:35 AM
Query optimization, SQL, SQL Server development, SQL Server Query

Error message when finding a database on SQL Server 2008
I have installed the Small Business Edition of SQL Server 2008, and I have created a Microsoft Dynamics NAV database on this SQL Server. However, when trying to locate the server from a pc in the office, it does not find the database. The error message is: “The 192.168.0.7″ server cannot be found.” 192.168.0.7 is [...]

Answer Question   |  February 4, 2009  6:44 PM
Small Business Server, SQL Server 2008, SQL Server databases, SQL Server error messages

Troubleshooting a DTS job failure on SQL Server
I have a DTS job that failed on my SQL Server, but it doesn’t have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?

Answer Question   |  February 4, 2009  6:40 PM
DTS, DTS packages, SQL Server DTS

Why and how to performance tune SQL Server 2005
Why do you have to tune SQL Server 2005 for performance, how do you go about tuning it, and, for tuning purposes, which is better – SQL Server 2000 or SQL Server 2005?

Answer Question   |  February 4, 2009  6:30 PM
SQL Server 2000, SQL Server 2005, SQL Server performance tuning

Stored Procedures, One Database, Different Software Releases
Hi Everyone. Currently at my work we use SQL in our VB.NET code. I have previously always used stored procedures for all of their benefits. My company has said that our customers might use different versions of our software against its one database. For example: While a customer is migrating from release 1 to release [...]

Answer Question   |  February 24, 2009  9:20 AM
Release management, Software maintenance, SQL, Stored Procedures, VB.NET, Visual Basic .NET

sqldumper
is sqldumper caused by low memory in computer if not what is it caused by and how do i get rid of it

Answer Question   |  February 4, 2009  7:11 PM
SQL, sql dumper, SQL performance, SQL Server memory, SQL Server performance

How to make installer of VB.NET including SQL Server 2000?
I had done my project in vb.net with sql server 2000 but it’s installer doesn’t work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn’t working please help me.I am stuck in here.thanks in advance.

Answer Question   |  February 10, 2009  11:32 AM
Database connectivity, Setup and deployment, SQL Server 2000, VB Setup File, VB.NET, Visual Basic, Visual Basic .NET

Converting date time in C#
hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in [...]

Answer Question   |  February 3, 2009  8:07 AM
C, Data Types, DateTime, SQL, VARCHAR, XML

Date Parameters in SSRS – showing total by day as well as by total by parameter chosen
I have a date range parameter set up in SSRS. I need to show the total for each day chosen in the data range parameter as well as the grand total of the entire filtered selection. Is this possible?

Answer Question   |  February 2, 2009  9:56 PM
SSRS, SSRS 2005

SQL Server 2008 compression experiences?
We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of the biggest drivers for this is the compression capability in SS2008. We expect to shrink our 2TB database down to about 500GB (proven in testing), and get the comparable IO performance improvements (4x faster reads – also proven in testing). [...]

Answer Question   |  February 2, 2009  8:50 PM
SQL Server 2005 to SQL Server 2008 Migration, SQL Server 2008, SQL Server 2008 Compression, SQL Server Compression, SQL Server migration