Questions & Answers

  • Is a Microsoft certified database administrator (MSDBA) certification course good with my SQL Server experience?

    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...

    NetworkingATE1,545 pointsBadges:
  • Looking for detailed synchronization logging in SQL Server 2008

    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...

    SBatSI415 pointsBadges:
  • Connecting MS SQL server and database.

    Hi, i am trying to connect MS SQL server and database from visual c++ 2005. Can anybody help me please.

    Aranjan5 pointsBadges:
  • Retrieving data from two tables in SQL Server 2005 Expree Edition using C#

    how to Retrieve data from two tables in SQL Server 2005 Expree Edition using C#.

    Aras10 pointsBadges:
  • Running SSIS on a clustered server with SQL Server 2005

    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....

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 ‘alter user’

    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...

    Db23290 pointsBadges:
  • Sql Server Linked Server to iSeries

    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...

    Technet30 pointsBadges:
  • Notes 6.5 – All events view slowness

    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

    ChristineIT5 pointsBadges:
  • Connecting to SQL Server 2005 after installing PowerBuilder

    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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I write the code to connect an .aspx webform to a MS SQL server and database

    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...

    Twinkles rules5 pointsBadges:
  • AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.

    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.

    Theraven35 pointsBadges:
  • SQL Server Profiler returns incorrect hostname

    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...

    Boreal0 pointsBadges:
  • Create a database in SQL Server 2005

    Create a database in sql server 2005 but database name passed as parameter into a stored procedure

    Let5 pointsBadges:
  • Link Tables in AS400 to SQL Server 2008

    Has anyone set up a link server to their AS400 from SQL Server 2008/5?

    Jaymz69765 pointsBadges:
  • bulk update in sql server 2005

    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...

    MinteeLoki5 pointsBadges:
  • Connecting to SQL Server from an Oracle procedure

    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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need help setting Transaction Log properties in SQL Server 2000

    I'd like some help determining what would be the best settings for my transaction log properties. When our SQL Server 2000 SP4 Database was setup it was done by developers without detailed information regarding all of the possible settings so most settings were left at their defaults. I have been...

    KansasCoder40 pointsBadges:
  • SQL Server 2005 database mirroring over a VPN router

    Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Window versus Unix?

    please advice : Window Vs Unix please tell me why unix not window  or why windows not unix

    Mohaned1st15 pointsBadges:
  • Lotus Notes error when archiving any email

    When archiving any email that was sent using stationery, it gives me the error "Notes error: Some documents were not archived because they had already been pruned. See the archive log for additional details." Unfortunately, our administrator has turned the log off. Can anyone please advise how to...

    SharonE45 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following