how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003
Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over internet. I was thinking of using ssis [...]
Answer Question
| May 30, 2008 4:56 AM
SQL Server 2005, SSIS, Update remote database
Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over internet. I was thinking of using ssis [...]
Answer Question
| May 30, 2008 4:56 AM
SQL Server 2005, SSIS, Update remote database
Journey from SQL/400 to SQL Server Development
I’m fairly comptent with SQL/400 , scripting, etc. – - how difficult would it be to applying this to learning something like “SQL Server” ?
Answer Question
| May 29, 2008 3:09 PM
SQL, SQL Server, SQL/400
I’m fairly comptent with SQL/400 , scripting, etc. – - how difficult would it be to applying this to learning something like “SQL Server” ?
Answer Question
| May 29, 2008 3:09 PM
SQL, SQL Server, SQL/400
Ask a question. Win an IT Knowledge Exchange T-shirt
Community members Brent and I decided to put together a cool little contest. It is very simple. For the next week, starting today, all members that ask questions will be entered to win 1 of 5 IT Knowledge Exchange t-shirts we will be giving away. The more questions you ask the better your chances are [...]
Answer Question
| June 17, 2008 2:30 PM
AS/400, CIO, DataCenter, Development, Exchange, ITKE, Lotus Domino, Microsoft Windows, Networking, SQL Server, Storage, Virtualization, VoIP
Community members Brent and I decided to put together a cool little contest. It is very simple. For the next week, starting today, all members that ask questions will be entered to win 1 of 5 IT Knowledge Exchange t-shirts we will be giving away. The more questions you ask the better your chances are [...]
Answer Question
| June 17, 2008 2:30 PM
AS/400, CIO, DataCenter, Development, Exchange, ITKE, Lotus Domino, Microsoft Windows, Networking, SQL Server, Storage, Virtualization, VoIP
as400 db2 to sql server 2005
how can we take a db2 backup tape and dump to a sql server 2005 database?
Answer Question
| April 23, 2010 4:47 PM
AS/400 DB2, DB2, SQL Server 2005
how can we take a db2 backup tape and dump to a sql server 2005 database?
Answer Question
| April 23, 2010 4:47 PM
AS/400 DB2, DB2, SQL Server 2005
Database Newbie
Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with [...]
Answer Question
| May 28, 2008 10:00 PM
Database, Database security, SQL Server, SQL Server 2005, SQL Server 2008, VB.NET 2008, Visual Basic .NET
Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with [...]
Answer Question
| May 28, 2008 10:00 PM
Database, Database security, SQL Server, SQL Server 2005, SQL Server 2008, VB.NET 2008, Visual Basic .NET
Using Oracle 10g Stored proc in SSRS 2005
I’m trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run the [...]
Answer Question
| July 14, 2009 1:08 AM
Oracle 10g, Oracle stored procedures, SQL Server Reporting Services, SSRS 2005, Stored Procedures
I’m trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run the [...]
Answer Question
| July 14, 2009 1:08 AM
Oracle 10g, Oracle stored procedures, SQL Server Reporting Services, SSRS 2005, Stored Procedures
SQL Macro
I need a SQL macro to populate a form? Please help. wkharrell@gmail.com
Answer Question
| May 27, 2008 11:12 PM
Development, SQL, SQL macros
I need a SQL macro to populate a form? Please help. wkharrell@gmail.com
Answer Question
| May 27, 2008 11:12 PM
Development, SQL, SQL macros
Encryption Form SQL Server 2000
I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it ….. Regards, Sahil
Answer Question
| May 27, 2008 11:32 AM
Data transfer, Encryption, SQL Server 2000, SQL Server migration
I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it ….. Regards, Sahil
Answer Question
| May 27, 2008 11:32 AM
Data transfer, Encryption, SQL Server 2000, SQL Server migration
COUNT(*) Statement is slow with 3+ million records
Hi, I have a table with 30 columns, a indexed unique field and 3+ million records. When I try a simple SELECT COUNT(*) statement its take 5-7 sec. to give the output. And I am showing this output to my front end application ASP.Net taking 1 min to show the count in front end. I [...]
Answer Question
| May 26, 2008 7:23 AM
SQL Server
Hi, I have a table with 30 columns, a indexed unique field and 3+ million records. When I try a simple SELECT COUNT(*) statement its take 5-7 sec. to give the output. And I am showing this output to my front end application ASP.Net taking 1 min to show the count in front end. I [...]
Answer Question
| May 26, 2008 7:23 AM
SQL Server
Reporting Services – Deploy error
Hi there, I recently changed my computer name, and from that moment the SQL Server Development Studio couldn’t deploy my project anymore. It successfully builds the project, but can’t deploy it. It returns the following error message: “A connection could not be made to the report server http://localhost/Reports$NAME Additional Information: The attemp to connect to [...]
Answer Question
| May 23, 2008 6:40 AM
Reporting Services, Reporting Services Configuration Manager, SQL Server Development Studio, SQL Server Reporting Services
Hi there, I recently changed my computer name, and from that moment the SQL Server Development Studio couldn’t deploy my project anymore. It successfully builds the project, but can’t deploy it. It returns the following error message: “A connection could not be made to the report server http://localhost/Reports$NAME Additional Information: The attemp to connect to [...]
Answer Question
| May 23, 2008 6:40 AM
Reporting Services, Reporting Services Configuration Manager, SQL Server Development Studio, SQL Server Reporting Services
Need to format to hh:mm:ss
I’m creating a report in SSRS 2000 and one field reflects time spend on phone daily. However is being displayed as for example, OutboundHours 4818. How can I get this to display in the report as hh:mm:ss. Is there code that I can plug into a variable or syntax that will accomplish this? I don’t [...]
Answer Question
| May 23, 2008 8:08 PM
SSRS 2000
I’m creating a report in SSRS 2000 and one field reflects time spend on phone daily. However is being displayed as for example, OutboundHours 4818. How can I get this to display in the report as hh:mm:ss. Is there code that I can plug into a variable or syntax that will accomplish this? I don’t [...]
Answer Question
| May 23, 2008 8:08 PM
SSRS 2000
IT Career Path
I am a new graduate with 1 year of experince in a well known Aircraft Manufacturing company. My title is “Database Administrator – Operations” and I deal mainly with SQL Server back ends with Visual Basic or HTML front ends. I currently deal with many internal customers and relay the feedback to the rest of [...]
Answer Question
| May 23, 2008 7:26 PM
Database, IT careers, SAP careers, SAP certifications, SQL Server
I am a new graduate with 1 year of experince in a well known Aircraft Manufacturing company. My title is “Database Administrator – Operations” and I deal mainly with SQL Server back ends with Visual Basic or HTML front ends. I currently deal with many internal customers and relay the feedback to the rest of [...]
Answer Question
| May 23, 2008 7:26 PM
Database, IT careers, SAP careers, SAP certifications, SQL Server
Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit
The proposed data warehouse platform will be a 64 bit platform – both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I’ll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?
Answer Question
| May 21, 2008 4:35 PM
64 bit architecture, Data warehouse, ETL, SQL Server 2005 (64-bit)
The proposed data warehouse platform will be a 64 bit platform – both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I’ll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?
Answer Question
| May 21, 2008 4:35 PM
64 bit architecture, Data warehouse, ETL, SQL Server 2005 (64-bit)
Setting up access rights in a SQL Server 2005 database
Hello, I’m using MS SQL Server 2005. I’m connecting to the server via ADO. I have a question about access rights. Let me explain this with an example. Let’s say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL Server user that will [...]
Answer Question
| May 21, 2008 2:09 PM
Access Rights, ADO, Permissions and settings, SQL Server 2005, SQL Server security
Hello, I’m using MS SQL Server 2005. I’m connecting to the server via ADO. I have a question about access rights. Let me explain this with an example. Let’s say I have a database named DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL Server user that will [...]
Answer Question
| May 21, 2008 2:09 PM
Access Rights, ADO, Permissions and settings, SQL Server 2005, SQL Server security
How to restore a SQL Server 2000 database using a backup
Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.
Answer Question
| April 19, 2013 1:52 PM
Backup, Backup & recovery, SQL Server 2000, SQL Server backup and restore
Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.
Answer Question
| April 19, 2013 1:52 PM
Backup, Backup & recovery, SQL Server 2000, SQL Server backup and restore
Can SQL Server 2005 32-bit and SQL Server 2005 64-bit co-exist on the same cluster machine?
Can SQL Server 2005 32 bit and SQL Server 2005 64 bit co-exist on the same cluster machine?
Answer Question
| November 9, 2012 1:46 PM
SQL Server 2005, SQL Server 2005 (64-bit), SQL Server clustering, SQL Server integration/interoperability
Can SQL Server 2005 32 bit and SQL Server 2005 64 bit co-exist on the same cluster machine?
Answer Question
| November 9, 2012 1:46 PM
SQL Server 2005, SQL Server 2005 (64-bit), SQL Server clustering, SQL Server integration/interoperability
Execution time is varying with query analyzer and visual studio 2005
when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue
Answer Question
| May 21, 2008 6:24 AM
SQL, SQL Query Analyzer, SQL Server stored procedures, Stored Procedures, Visual Studio
when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue
Answer Question
| May 21, 2008 6:24 AM
SQL, SQL Query Analyzer, SQL Server stored procedures, Stored Procedures, Visual Studio
OPEN .DTS WITH WRONG APPLICATION
JUST OPEN .DTS FILE OF THE SQL SERVER 2000 WITH NOTEPAD APPLICATION, AND THE .DTS LOGO HAS BEEN CHANGED TO NTOEPAD LOGO, IS IT POSSIBLE TO CHANGE BACK TO .DTS LOGO? THANKS.
Answer Question
| May 20, 2008 8:37 AM
SQL Server 2000
JUST OPEN .DTS FILE OF THE SQL SERVER 2000 WITH NOTEPAD APPLICATION, AND THE .DTS LOGO HAS BEEN CHANGED TO NTOEPAD LOGO, IS IT POSSIBLE TO CHANGE BACK TO .DTS LOGO? THANKS.
Answer Question
| May 20, 2008 8:37 AM
SQL Server 2000
Sql server 2005 database filesize auto grow
Hi i’m running sql server 2005 sp2 on a w2k cluster; i’m expericing this issue whereby the file size of a particular database will auto increase even though no one is even accessing it. Is there anyway to findout the cause of this issue or how can i stop the database from auto increasing the [...]
Answer Question
| May 20, 2008 7:36 AM
SQL Server 2005, SQL Server performance tuning
Hi i’m running sql server 2005 sp2 on a w2k cluster; i’m expericing this issue whereby the file size of a particular database will auto increase even though no one is even accessing it. Is there anyway to findout the cause of this issue or how can i stop the database from auto increasing the [...]
Answer Question
| May 20, 2008 7:36 AM
SQL Server 2005, SQL Server performance tuning
Random number generation
Hi, I have a 6 digit number. I need to make this as a 10 characters with those 6 digits within it. For eg, if my input number is 123456, the result should be a4y2d365p1. some combination of characters with the original 6 digit numbers. Please do let me know if this could be done [...]
Answer Question
| May 20, 2008 6:44 PM
Random Number Generator, SQL, SQL Server
Hi, I have a 6 digit number. I need to make this as a 10 characters with those 6 digits within it. For eg, if my input number is 123456, the result should be a4y2d365p1. some combination of characters with the original 6 digit numbers. Please do let me know if this could be done [...]
Answer Question
| May 20, 2008 6:44 PM
Random Number Generator, SQL, SQL Server
