Forum Replies Created

Viewing 15 posts - 48,616 through 48,630 (of 49,571 total)

  • RE: How to merge 2 resultset?

    PinAnt

    Could you post the structure and data your two original tables and what you want as a result.

  • RE: Error in inserting Value

    I assume the FileID is the identity column. Try this for the insert statement.

    insert wms_TrnRecoveryDetails ([User_ID],[FileName], FileModifiedDate,  Filesize, system, Bookid, stageid, Divisionid, wmsid, Activityid, jobcode)

    values (@User_ID, @Filename, @FileModifiedon, @Filesize, @System,...

  • RE: Run-time error ''''-2147467259(80004005)'''' :SQL Server does not exist or access denied

    Check the server name and check the login name being used.

    That message usually means that the server name specified is not a running sql server or that the login...

  • RE: Scheduling a DTS package

    Possibly due to security. When you run the package manually, it runs under your credentials. When its scheduled it runs under the service account of SQL Agent.

    It could be connections...

  • RE: SQL 2005 to SQL 2000

    Wouldn't need any scripting.

    Set up snapshot replication from the 2005 machine to a 2000 machine. Snapshot copies the entire database across, structure and data. Then back that 2000 database...

  • RE: SQL 2005 to SQL 2000

    Here's a way out idea.

    How about replication to a 2000 server that you control? Then you can take a backup of that and send it off. Even if you just...

  • RE: SQL 2005 to SQL 2000

    The underlying structure of the code to create the databases is basically the same.

    The code may be basically the same, but the structure of the database, specifically around the system tables...

  • RE: SQL 2005 Sort Order Problem

    What's the server's collation and what's the database's collation?

    You can get these errors wen those two are different and a temp table is used, or a query uses a worktable...

  • RE: Opening a symmetric key in a stored procedure

    What's the error you get?

  • RE: Most bizzare issue of all times (Serious Performance Issue)

    What are the specs of the prod and dev servers? how much memory is allocated to SQL on each of them? Is there anything else running on those servers?

    I'd run...

  • RE: Setting up an endpoint for TSQL

    What are you trying to create an endpoint for?

    According to Books Online, the syntax for a TSQL endpoint is

    CREATE ENDPOINT endPointName [ AUTHORIZATION login ]

    [ STATE = { STARTED | STOPPED...

  • RE: trying to update an xml value!!

    I'll dig into schemas, if I get a chance. See if I can figure anything out. XML is not something I've worked much with though.

  • RE: Deadlock - Killing the correct process ID

    I would advise against automating a kill script. I've been in that situation. Best thing is to resolve the cause of the problem, not to have an automated process to...

  • RE: how to improve performance of the query with unions

    2) Use of both distinct and union - each require tempdb and sorting --> inefficient.

    the optimiser is smart enough not to do both. In cases I've seen like this there's...

  • RE: Deadlock - Killing the correct process ID

    If you have a deadlock, SQL's own internal deadlock detector will detect the deadlock, pick a victim and kill that connection. You don't have to do anything.

    Or are you talking...

Viewing 15 posts - 48,616 through 48,630 (of 49,571 total)