Answer a Question, Win The Official Ubuntu Server Book!
At the beginning of the month, we gave away The Official ubuntu Book, and now we’re giving away The Official ubuntu Server Book, Second Ed.! The book includes a DVD that contains the versions of Ubuntu Server needed for different CPU architectures. You also receive a code for a free online version of the book. [...]
Answer Question
| August 27, 2010 2:17 PM
Contests, Data Encryption, Giveaways, IT Books, Linksys Routers, Open IT Forum, SQL Server 2008, Wireless in 2010, WLAN
At the beginning of the month, we gave away The Official ubuntu Book, and now we’re giving away The Official ubuntu Server Book, Second Ed.! The book includes a DVD that contains the versions of Ubuntu Server needed for different CPU architectures. You also receive a code for a free online version of the book. [...]
Answer Question
| August 27, 2010 2:17 PM
Contests, Data Encryption, Giveaways, IT Books, Linksys Routers, Open IT Forum, SQL Server 2008, Wireless in 2010, WLAN
SQL problem: Adapting code fragment
How do I adapt the fragment of code below to show: a) Two columns – the Filipino Population and the Total Population b) The Filipino Population as a percentage of the total population SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(*)FROM POPDATA WHERE POPDATA.ANCNUMBER=720 GROUP BY POPDATA.CITYNUM ORDER BY COUNT(*) DESC;
Answer Question
| August 23, 2010 10:56 AM
Access 2007, SQL, SQL commands, SQL Server
How do I adapt the fragment of code below to show: a) Two columns – the Filipino Population and the Total Population b) The Filipino Population as a percentage of the total population SELECT DISTINCTROW POPDATA.CITYNUM, COUNT(*)FROM POPDATA WHERE POPDATA.ANCNUMBER=720 GROUP BY POPDATA.CITYNUM ORDER BY COUNT(*) DESC;
Answer Question
| August 23, 2010 10:56 AM
Access 2007, SQL, SQL commands, SQL Server
Database Security: SQL Server 2005 security login
Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me……….
Answer Question
| August 23, 2010 12:51 PM
Database security, SQL Server 2005, SQL Server 2005 security, SQL Server security, SQL Server Security Login, Windows XP
Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me……….
Answer Question
| August 23, 2010 12:51 PM
Database security, SQL Server 2005, SQL Server 2005 security, SQL Server security, SQL Server Security Login, Windows XP
Using mdf file in website
When you’ve developed e website with vis stud, including an aspnetdb.mdf file and a database file for the webcontent, how can you use these mdf files on the isp server where sqlserver 2005 is running? A normal connectionstring in the web,sonfig file gives an error about the attachdbfilename being a wrong parameter.
Answer Question
| August 23, 2010 4:15 AM
.MDF files, ASP.NET, SQL Server, SQL Server 2005, Visual Studio
When you’ve developed e website with vis stud, including an aspnetdb.mdf file and a database file for the webcontent, how can you use these mdf files on the isp server where sqlserver 2005 is running? A normal connectionstring in the web,sonfig file gives an error about the attachdbfilename being a wrong parameter.
Answer Question
| August 23, 2010 4:15 AM
.MDF files, ASP.NET, SQL Server, SQL Server 2005, Visual Studio
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
