SQL Server 2008 Restore error message
I get this error when trying to restore a 30 mg database “Callback:SQL Server 2008: Out of memory on restore” and then get the error “”There is insufficient system memory in resource pool ‘internal’” Anyone have any ideas?
Answer Question
| August 27, 2010 2:25 AM
SQL Server, SQL Server 2003, SQL Server 2005, SQL Server 2008 error messages, SQL Server restore
I get this error when trying to restore a 30 mg database “Callback:SQL Server 2008: Out of memory on restore” and then get the error “”There is insufficient system memory in resource pool ‘internal’” Anyone have any ideas?
Answer Question
| August 27, 2010 2:25 AM
SQL Server, SQL Server 2003, SQL Server 2005, SQL Server 2008 error messages, SQL Server restore
Updating SQL express to SQL 2008 R2 on server 2008 with sharepoint 2007
At present we are running a Windows 2008 Server which has Sharepoint 2007 installed and houses our exchange server. Apparently only the Express version of SQL server was installed initially and now the 4GB database limit is affecting our intranet. Have been advised that we need to update to SQL Server 2008 and what I [...]
Answer Question
| August 20, 2010 3:28 AM
SharePoint 2007, SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server 2008 Adoption, SQL Server Upgrade, Windows Server 2008
At present we are running a Windows 2008 Server which has Sharepoint 2007 installed and houses our exchange server. Apparently only the Express version of SQL server was installed initially and now the 4GB database limit is affecting our intranet. Have been advised that we need to update to SQL Server 2008 and what I [...]
Answer Question
| August 20, 2010 3:28 AM
SharePoint 2007, SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server 2008 Adoption, SQL Server Upgrade, Windows Server 2008
Recovering data from crashed database
i i have a question. my database is crash .i don’t have present backups.but i’m having last week backups. and backup strategy sunday 10 p.m full backup everyday 1 p.m differential backup every one hour transaction log backup please give me reply as soon as thanks & regards venkat
Answer Question
| August 20, 2010 7:31 AM
Backup, Backup & recovery, Database Recovery, DBA, SQL Server, SQL Server backup
i i have a question. my database is crash .i don’t have present backups.but i’m having last week backups. and backup strategy sunday 10 p.m full backup everyday 1 p.m differential backup every one hour transaction log backup please give me reply as soon as thanks & regards venkat
Answer Question
| August 20, 2010 7:31 AM
Backup, Backup & recovery, Database Recovery, DBA, SQL Server, SQL Server backup
ASP Web page database?
I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it’s good still with access. (I Know basically ”everything” is SQL but please give [...]
Answer Question
| August 18, 2010 5:17 PM
ASP.NET, ASP.NET Web applications, SQL Access, SQL Database, SQL Developer
I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it’s good still with access. (I Know basically ”everything” is SQL but please give [...]
Answer Question
| August 18, 2010 5:17 PM
ASP.NET, ASP.NET Web applications, SQL Access, SQL Database, SQL Developer
SQL Server 2005 & 2008 on a Cluster in Production
Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because they were so [...]
Answer Question
| August 18, 2010 2:46 PM
Cluster management, Clustered servers, SQL Server (64-bit), SQL Server 2005, SQL Server 2008, SQL Server 2008 64-bit, SQL Server administration, SQL Server clustering
Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because they were so [...]
Answer Question
| August 18, 2010 2:46 PM
Cluster management, Clustered servers, SQL Server (64-bit), SQL Server 2005, SQL Server 2008, SQL Server 2008 64-bit, SQL Server administration, SQL Server clustering
High Disk usage on SQL Server 2005
We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions. Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high disk [...]
Answer Question
| August 31, 2010 8:58 AM
Disk usage, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 Database, SQL Server 3.5 Compact Edition
We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions. Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high disk [...]
Answer Question
| August 31, 2010 8:58 AM
Disk usage, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 Database, SQL Server 3.5 Compact Edition
Incremental backup in SQL server 2005 and SQL Server 2005 express
Question: a) steps to backup the daily incremental in sql server 2005. b) steps to backup the daily incremental in sql server 2005 express.
Answer Question
| August 19, 2010 6:04 AM
Backup, Incremental backup, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 Express, SQL Server backup
Question: a) steps to backup the daily incremental in sql server 2005. b) steps to backup the daily incremental in sql server 2005 express.
Answer Question
| August 19, 2010 6:04 AM
Backup, Incremental backup, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 Express, SQL Server backup
Importing large sets of Excel 2000 data to SQL database
I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?
Answer Question
| August 18, 2010 8:08 PM
Data migration, Excel 2000, Excel Database, Excel worksheets, SQL Database, SQL migration
I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?
Answer Question
| August 18, 2010 8:08 PM
Data migration, Excel 2000, Excel Database, Excel worksheets, SQL Database, SQL migration
Exclude Login from SQL Audit Trace
I’m working on a stored procedure to capture SQL Server 2005 Audit events. There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I’m using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login from being audited?
Answer Question
| August 16, 2010 6:06 PM
Audit Trace, SQL audit, SQL Server, SQL Server 2005, SQL stored procedures
I’m working on a stored procedure to capture SQL Server 2005 Audit events. There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I’m using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login from being audited?
Answer Question
| August 16, 2010 6:06 PM
Audit Trace, SQL audit, SQL Server, SQL Server 2005, SQL stored procedures
Microsoft Retail Management System and SQL Server “Write” error
I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform. Store Operations Administrator and Manager are working with no problems. I know I am networked properly. When I open the POS I get the following: “Open-Incorrect Function”, I can click OK and sign on the the POS, then I get “Write-No [...]
Answer Question
| August 18, 2010 5:03 PM
Microsoft Retail Management, RMS, SQL Express, SQL Server 2005, SQL Server 2005 error messages, SQL Server error messages, Windows XP
I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform. Store Operations Administrator and Manager are working with no problems. I know I am networked properly. When I open the POS I get the following: “Open-Incorrect Function”, I can click OK and sign on the the POS, then I get “Write-No [...]
Answer Question
| August 18, 2010 5:03 PM
Microsoft Retail Management, RMS, SQL Express, SQL Server 2005, SQL Server 2005 error messages, SQL Server error messages, Windows XP
Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?
Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?
Answer Question
| August 16, 2010 2:48 PM
Database design, Print screen, Stored Procedures
Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?
Answer Question
| August 16, 2010 2:48 PM
Database design, Print screen, Stored Procedures
Crystal Report Not Coming on Screen
I am calling one crystal report from VB, it is running well on server. but when I run the same at client side, report comes on a screen for a second and disappered. Output is splash for a sec and return it to calling form. Can you please suggest me the possible reason with solution.
Answer Question
| August 16, 2010 7:06 AM
Crystal Reports, SQL Server 2005, VB 6.0, Visual Basic, Visual Basic 6.0, Windows Server 2003
I am calling one crystal report from VB, it is running well on server. but when I run the same at client side, report comes on a screen for a second and disappered. Output is splash for a sec and return it to calling form. Can you please suggest me the possible reason with solution.
Answer Question
| August 16, 2010 7:06 AM
Crystal Reports, SQL Server 2005, VB 6.0, Visual Basic, Visual Basic 6.0, Windows Server 2003
To increase number and combine data using sql
hi, I want to create a sql that generate a number of 4 digits with combination of character input.The number will increase if it is new record. for example : category = ‘P’ so the output will be : P-0001 for the next record the output will be : P-0002 any ideas? thanks.
Answer Question
| September 22, 2010 3:39 AM
Oracle, SQL, SQL Data Set, TOAD
hi, I want to create a sql that generate a number of 4 digits with combination of character input.The number will increase if it is new record. for example : category = ‘P’ so the output will be : P-0001 for the next record the output will be : P-0002 any ideas? thanks.
Answer Question
| September 22, 2010 3:39 AM
Oracle, SQL, SQL Data Set, TOAD
Joining 3 tables in SQL Server 2005
Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.
Answer Question
| August 12, 2010 12:37 PM
SQL Query, SQL query optimization, SQL Server, SQL Server 2005, SQL Server Query, SQL tables
Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.
Answer Question
| August 12, 2010 12:37 PM
SQL Query, SQL query optimization, SQL Server, SQL Server 2005, SQL Server Query, SQL tables
How to add two timings in SQL Server 2008
DECLARE @TIME1 VARCHAR(10),@DURATION VARCHAR(10) SET @TIME1=’10:00′ SET @DURATION=’00:25′ SELECT CONVERT(TIME(0),@TIME1)+CONVERT(TIME(0),@DURATION) I need to add two timings …suppose if the @time1 is ’10:00′ and the duration is ’15′ mns then it should show 10:15 … Any help highly appreciatable…
Answer Question
| May 18, 2012 7:59 AM
SQL Server, SQL Server 2008, SQL Server 2008 administration, T-SQL
DECLARE @TIME1 VARCHAR(10),@DURATION VARCHAR(10) SET @TIME1=’10:00′ SET @DURATION=’00:25′ SELECT CONVERT(TIME(0),@TIME1)+CONVERT(TIME(0),@DURATION) I need to add two timings …suppose if the @time1 is ’10:00′ and the duration is ’15′ mns then it should show 10:15 … Any help highly appreciatable…
Answer Question
| May 18, 2012 7:59 AM
SQL Server, SQL Server 2008, SQL Server 2008 administration, T-SQL
Crystal Reports – Rounding Nearest 1/8 Mile
I’m trying to create a report that will estimate our cost to a taxi vendor. I have the exact mileage, however I need to round to the nearest 1/8 of a mile. Does anyone have any idea how to do that either is Crystal Reports formula or SQL?
Answer Question
| August 12, 2010 1:59 AM
Crystal Reports, Crystal Reports 8.5, Crystal Reports formulas, SQL Server, SQL Server 2005
I’m trying to create a report that will estimate our cost to a taxi vendor. I have the exact mileage, however I need to round to the nearest 1/8 of a mile. Does anyone have any idea how to do that either is Crystal Reports formula or SQL?
Answer Question
| August 12, 2010 1:59 AM
Crystal Reports, Crystal Reports 8.5, Crystal Reports formulas, SQL Server, SQL Server 2005
SQL Server 2008 SSIS Update Command Performance Issue
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB [...]
Answer Question
| August 13, 2010 9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB [...]
Answer Question
| August 13, 2010 9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS
SQL Server 2005 Performance
1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?
Answer Question
| August 10, 2010 6:40 PM
SQL 2005 Database, SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance
1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?
Answer Question
| August 10, 2010 6:40 PM
SQL 2005 Database, SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance
How to roll back service pack in SQL server 2005
HOW TO ROLL BACK SERVICE PACK IN SQL SERVER 2005
Answer Question
| August 12, 2010 6:24 AM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server Service Packs
HOW TO ROLL BACK SERVICE PACK IN SQL SERVER 2005
Answer Question
| August 12, 2010 6:24 AM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server Service Packs
steps for accessing sql data through ado.net code over LAN NETWORK
steps for accesing sql data through ado.net code over LAN NETWORK
Answer Question
| August 10, 2010 5:29 AM
ADO.NET, SQL, SQL Data Set, SQL Server 2005, Visual Studio 2008, Windows 7, Windows 7 in 2010
steps for accesing sql data through ado.net code over LAN NETWORK
Answer Question
| August 10, 2010 5:29 AM
ADO.NET, SQL, SQL Data Set, SQL Server 2005, Visual Studio 2008, Windows 7, Windows 7 in 2010
