1
  • Why is SQL Server Management Studio taking so long?

    We're trying to do some offline maintenance work on one of our development databases but the "Take Offline" command (through SQL Server Management Studio) is working very slowly. We have no idea what might be causing it to run so slowly. There are no open connections too. Any ideas why this is...

    ITKE352,565 pointsBadges:
  • Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server

    Hello, I am getting the below error on customer production error, Query timeout expired - State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC's record sets. if I try to run that queries on SSMS directly I am not getting that error. How...

    Narasimhulu10 pointsBadges:
  • unable to connect sql server 2000 on network

    We have sql server 2000 instance on a machine say "comp1".The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the "comp1" via run and give password then i am able to connect through SSMS Can someone give a solution so that...

    Psingh1630 pointsBadges:
  • SQL Server Management Studio Express 2005

    I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?

    Sweetu20 pointsBadges:
  • UNICODE Characters

    When you run the query below: SELECT '✘ РǻuľO Čєѕaя ™' She is returning this: "?? Ulo C? To? ™" How to query return without truncating the text?

    Caiquedourado5 pointsBadges:
  • Select Value question in SSMS

    I am trying to select "log_comment" field with the max("stamp_date") field from "action_log" table where "field_index" field ='1007' I am getting more than just the row with the maximum stamp_date. Can someone please tell me what I'm doing wrong? Field_Index    Stamp_Date   Log_Comment...

    Sadams115 pointsBadges:
  • Exception from HRESULT: 0x80040104 (System.Windows.Forms)

    Program Location: at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at...

    Kambiz5 pointsBadges:
  • Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 pointsBadges:
  • having problem with SSIS package

    i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

    Atif5 pointsBadges:
1

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