Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Cisco, CRM, Data Management, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, OS, Routers, RPG, RPGLE, SAP, Security, Servers, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?
Hi there! I'm having a problem maintaining data integrity on a database table in MS SQL-Server 2000. To ensure maintaining the integrity I need to implement a Unique Constraint on one of my coloumns. The problem however is, that this coloumn also has to allow multiple NULL-values - but for every...
What is the main purpose of using indexes in SQL Server 2005?
I have a table called "ticketing" and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?
I am working in a data migration team on SQL Server. I am planning to do the Microsoft certified database administrator (MSDBA) course. Please let me know if this certification matches with the line of work I am doing, or if there is a more preferable certification that would contribute to my SQL...
We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...
Hi, i am trying to connect MS SQL server and database from visual c++ 2005. Can anybody help me please.
how to Retrieve data from two tables in SQL Server 2005 Expree Edition using C#.
We are using SQL Server 2005, 64-bit, on a Windows 2003 clustered server with Active/Passive 'A' and 'B' nodes. Databases are on a shared LUN. I can run all my SQL Server Integration Services packages on the 'A' node with no problem. When we fail over to the 'B' node, though, packages are failing....
Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domain\login_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. I know this method exist in SQL Server 2005, are any of you able...
Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on which...
In Lotus Notes, we are not able to view DIARY – ALL EVENTS -- Events by Customer view. The issue occurs only for the Events by Customer view and rest of the DIARY functions are working fine. We are able to open the view in "Designer" but it is taking more than one hour to updated
I have installed PowerBuilder 11.1 and I am trying to access SQL Server 2005 from my system. I use SQL Native Client for connecting to SQL Server 2005, but I am receiving the error, "Could not connect to Data Source". However, I am able to connect to that server using ODBC and SQL Server Management...
This was done in VS 2008 the web forms are registration and log in forms with aspx controls. I created the database and the tables ( but am having issues with the constraints for 3 columns). I am trying to find out how to connect the 2 and where would I put the code. I am not a programmer and I am...
I have a AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database. Is there a API or some method for doing this. Help.
We are using third party (Idera) software for auditing activity on our SQL Servers (2000) and some of the events collected do not contain correct data. Idera SQL Compliance Manager uses Profiler to generate trace files which it then parses elsewhere. Idera suggests that the problem lies outside of...
Create a database in sql server 2005 but database name passed as parameter into a stored procedure
Has anyone set up a link server to their AS400 from SQL Server 2008/5?
hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance...
We need to pull data from a SQL Server database, and our database is Oracle. How would I connect to SQL Server from an Oracle procedure?