import data from access into sql server 2005
hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into ms sqlserver 2005. I am receiving info into database access on a daily basis. so I have to do an auto job to import data from access into sql server 2005. I [...]
Answer Question
| November 24, 2010 10:30 AM
Migration, SQL Server 2005, Stored Procedures
hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into ms sqlserver 2005. I am receiving info into database access on a daily basis. so I have to do an auto job to import data from access into sql server 2005. I [...]
Answer Question
| November 24, 2010 10:30 AM
Migration, SQL Server 2005, Stored Procedures
case when issue
I recently came across behavior of a “case when” conditional expression that really confuses me. In this case: – CASE when isnumeric(‘-10.00%’) > 0 then convert(numeric, ‘-10.00%’) end —- the behavior is as I expected – the isnumeric() function returns 0 (cuz it ain’t no number) so the “then” is not evaluated and a null [...]
Answer Question
| January 29, 2008 1:39 AM
case when expression, Conditional expressions, SQL Server, T-SQL
I recently came across behavior of a “case when” conditional expression that really confuses me. In this case: – CASE when isnumeric(‘-10.00%’) > 0 then convert(numeric, ‘-10.00%’) end —- the behavior is as I expected – the isnumeric() function returns 0 (cuz it ain’t no number) so the “then” is not evaluated and a null [...]
Answer Question
| January 29, 2008 1:39 AM
case when expression, Conditional expressions, SQL Server, T-SQL
crystal x1 ms sql ver. 7
is crystal reports x1 compatible with ms sql version 7?
Answer Question
| November 21, 2007 8:01 PM
Crystal Reports, SQL Server 7.x
is crystal reports x1 compatible with ms sql version 7?
Answer Question
| November 21, 2007 8:01 PM
Crystal Reports, SQL Server 7.x
connecting VB2005 Express with remote msSQL2005 Express server
I’m trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!! the message is that the remote server do not allow remote connections!!! any ideas
Answer Question
| December 2, 2007 8:07 AM
Connect, Remote access servers, SQL Express, SQL Server 2005, VB 2005, Visual Basic
I’m trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!! the message is that the remote server do not allow remote connections!!! any ideas
Answer Question
| December 2, 2007 8:07 AM
Connect, Remote access servers, SQL Express, SQL Server 2005, VB 2005, Visual Basic
bcp utility in sql server 2005
hi,how to send logins from server to another server using bcp utility.
Answer Question
| July 8, 2010 5:51 AM
BCP Utility, SQL Server 2005
hi,how to send logins from server to another server using bcp utility.
Answer Question
| July 8, 2010 5:51 AM
BCP Utility, SQL Server 2005
how do i resolve two conflicting msde instances?
I have installed a second application that uses msde (ms sql server 2000) but during installation the installer found an existing msde db. when I try to use the 2nd application, it tries to log on using a different password, unsuccessfully. Does anyone know how to create a seperate msde instance that i can use? [...]
Answer Question
| November 14, 2007 8:42 PM
MSDE instance, SQL Server 2000, SQL Server 2000 Desktop Engine
I have installed a second application that uses msde (ms sql server 2000) but during installation the installer found an existing msde db. when I try to use the 2nd application, it tries to log on using a different password, unsuccessfully. Does anyone know how to create a seperate msde instance that i can use? [...]
Answer Question
| November 14, 2007 8:42 PM
MSDE instance, SQL Server 2000, SQL Server 2000 Desktop Engine
move db,logins
how can we transfer database and logins from sql server 2005 to another sql server 2005
Answer Question
| November 14, 2007 8:43 AM
Migration, SQL Server 2005
how can we transfer database and logins from sql server 2005 to another sql server 2005
Answer Question
| November 14, 2007 8:43 AM
Migration, SQL Server 2005
Disaster Recovery
How to get database back in disaster recovery when database is in emergency mode in sql server 2005 is there any option to update master then take a backup –please let me knw—
Answer Question
| December 2, 2007 10:40 AM
Disaster Recovery, SQL Server 2005
How to get database back in disaster recovery when database is in emergency mode in sql server 2005 is there any option to update master then take a backup –please let me knw—
Answer Question
| December 2, 2007 10:40 AM
Disaster Recovery, SQL Server 2005
MS SQL 2000 memory leak
Hi We are running Adobe Workflow server which is based on SQL 2000. Both appliaction and SQL 2000 rside on the same server WIndows 2003. Lately we faced the problem of Time Out from Adobe and it seems to be that SQL is consuming allot of memeory. When checked Tak Manager we found out that [...]
Answer Question
| December 2, 2007 12:52 PM
Memory leak, SQL, SQL Server 2000
Hi We are running Adobe Workflow server which is based on SQL 2000. Both appliaction and SQL 2000 rside on the same server WIndows 2003. Lately we faced the problem of Time Out from Adobe and it seems to be that SQL is consuming allot of memeory. When checked Tak Manager we found out that [...]
Answer Question
| December 2, 2007 12:52 PM
Memory leak, SQL, SQL Server 2000
Can’t bring master database back online
hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did’t get that one into online(production side)wht is root cause for that?
Answer Question
| December 1, 2010 11:27 AM
SQL Server 2005, SQL Server database, SQL Server errors, SQL Server Master Database
hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did’t get that one into online(production side)wht is root cause for that?
Answer Question
| December 1, 2010 11:27 AM
SQL Server 2005, SQL Server database, SQL Server errors, SQL Server Master Database
DB Triggers and JPA
I have a physical file/table, on an iSeries, into which I drop a record containing UserID and Password. This action in turn fires a trigger that ends up calling the api QSYGETPH to verify the user’s login credentials. This has been working for years under our previous architecture, wherein we inserted the record via SQL [...]
Answer Question
| February 20, 2010 4:27 PM
AS/400, iSeries, JPA, Spring, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Toplink, Triggers, XFire
I have a physical file/table, on an iSeries, into which I drop a record containing UserID and Password. This action in turn fires a trigger that ends up calling the api QSYGETPH to verify the user’s login credentials. This has been working for years under our previous architecture, wherein we inserted the record via SQL [...]
Answer Question
| February 20, 2010 4:27 PM
AS/400, iSeries, JPA, Spring, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Toplink, Triggers, XFire
Securing dynamic file uploads to a SQL 2005 Server database
I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks
Answer Question
| March 1, 2008 9:16 PM
SQL Server security
I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks
Answer Question
| March 1, 2008 9:16 PM
SQL Server security
USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]
Answer Question
| December 2, 2007 1:40 PM
Database, SQL, Stored Procedures, USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]
Answer Question
| December 2, 2007 1:40 PM
Database, SQL, Stored Procedures, USE DATABASE
SQL 2005 Restore DB with Multiple files in Primary File group
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee
Answer Question
| December 2, 2007 8:58 PM
Database, Restore, SQL, SQL Server, SQL Server 2005
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee
Answer Question
| December 2, 2007 8:58 PM
Database, Restore, SQL, SQL Server, SQL Server 2005
Indexing Fact Tables for a data warehouse
Hi I am reviewing the indexing the fact tables of a data warehouse and it currently has a clustered primary key and quite a few VERY LARGE covering indexes comprising lots of columns. The selectivity of the columns other than the primary key is very low; mostly close to 0% with a couple around 15 [...]
Answer Question
| December 2, 2007 1:17 AM
Data warehouse, SQL Server 2005
Hi I am reviewing the indexing the fact tables of a data warehouse and it currently has a clustered primary key and quite a few VERY LARGE covering indexes comprising lots of columns. The selectivity of the columns other than the primary key is very low; mostly close to 0% with a couple around 15 [...]
Answer Question
| December 2, 2007 1:17 AM
Data warehouse, SQL Server 2005
7 SQL Servers working seperately need joining.
I am working in small bank with 6 branches and a Headquarter. Each Branch is running a SQL server with 8 workstation connected to it over LAN. At each day end branches closes their work send their data to headquarter in an export file format. Where it is imported to Headquarter Sql Server database through [...]
Answer Question
| December 2, 2007 6:02 AM
Networking, SQL Server 2000
I am working in small bank with 6 branches and a Headquarter. Each Branch is running a SQL server with 8 workstation connected to it over LAN. At each day end branches closes their work send their data to headquarter in an export file format. Where it is imported to Headquarter Sql Server database through [...]
Answer Question
| December 2, 2007 6:02 AM
Networking, SQL Server 2000
Interesting Outout in SQL SERVER
Folks, If I query like this, am getting the following Output.. Y is this so ??? SELECT 10_to_100 _to_100 ———– 10 SELECT 25_from _from ———– 25 If anybody is familiar with the reason, y the part of the data in select query getting truncated.. pls share… cheers ! ash
Answer Question
| December 2, 2007 9:22 PM
SQL Server
Folks, If I query like this, am getting the following Output.. Y is this so ??? SELECT 10_to_100 _to_100 ———– 10 SELECT 25_from _from ———– 25 If anybody is familiar with the reason, y the part of the data in select query getting truncated.. pls share… cheers ! ash
Answer Question
| December 2, 2007 9:22 PM
SQL Server
Accessing MS SQL Server database from the iSeries
How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting “host name not found” on as400. Thanks, Lan
Answer Question
| February 20, 2010 5:26 PM
AS/400, SQL Database, SQL Server
How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting “host name not found” on as400. Thanks, Lan
Answer Question
| February 20, 2010 5:26 PM
AS/400, SQL Database, SQL Server
Question on JOIN Clause
Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash
Answer Question
| November 2, 2007 9:00 AM
JOIN statement, SQL Server 2000, SQL Server 2005
Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash
Answer Question
| November 2, 2007 9:00 AM
JOIN statement, SQL Server 2000, SQL Server 2005
oracle quires
while executing the following qurie ‘inser into custmaster select * from tnjcust where seccode=’431′;’ answer is not enough valus
Answer Question
| October 29, 2007 1:36 PM
Oracle, SELECT statement
while executing the following qurie ‘inser into custmaster select * from tnjcust where seccode=’431′;’ answer is not enough valus
Answer Question
| October 29, 2007 1:36 PM
Oracle, SELECT statement
