Forum Replies Created

Viewing 15 posts - 106 through 120 (of 125 total)

  • RE: insert data in detail with FK (autoIncrement) from Master Table

    Exactly, there is no distinction, based on data, user can change/update whole record any column coz i don't know what changes user do but not the primary key (Auto ID). I want to...

  • RE: table from replication??

    If there is no such trigger on tables, how your replication is working? without Triggers I never saw database that replicates somewhere. Due you realize it or not?

  • RE: table from replication??

    If you don't have permission to see distribution database, see triggers of that table for Database B, if there are three triggers (insert, update and delete) it may looks like...

  • RE: Save password

    Which Query Analyzer version ur using, In Management Studio 2005 query analyzer has an option to save login id and password when selecting SQK authentication but in SQL Server 2000...

  • RE: Sql Query

    Thanks for suggestion, I have opended a new Thread for help.

    Plz help me solving my query.

    Thanks once again.

     

    Shamshad Ali

  • RE: Sql Query

    Hi all,

     

    I want result in one select of following table as below:

     

    RowID              Message          MessageType

    1                     To               ‘some name’

    2                     From           ‘My Name’

    3                     To              ...

  • RE: How to sync users and logins in SQL2005 after restore

    Thanks for pointing out my mistake, Try following- if this help out :

    /*Generate the 'sp_change_users_login' statements necessary to synch all users in all databases on the server.*/

    set...

  • RE: How to sync users and logins in SQL2005 after restore

    Replace your cursor query with the following, first you test your query then put for cursor, I have not yet tested your all lines of script.

    SELECT @UserName

  • RE: Question of the Day for 11 May 2006

    From that Reference link it also saying as below:

    You want the server to guarantee that the data is well formed and also optionally validate your data according to XML schemas.

    I...

  • RE: Business Intelligence Development Studio not working

    I have fixed it.

    Thanks for closing this POST.

    ======================================

    Here is the solution:

    You should make sure that Visual Studio is still installed.

    If you didn't previously have VS installed, the BI Dev...

  • RE: Question of the Day for 07 Feb 2006

    Yes these days question are usually from SQL SERVER 2005. Until we all move to SQL Server 2005 we must mention to which version of SQL Server it belonging.

    From BOL as it states that:...

  • RE: Deleted Merge Replication

    use the Enterprise Manager to remove- It will remove all its dependent objects aswell, then you run sp_RemoveDBReplication

     

    Shamshad Ali.

  • RE: Error in replication

    With continuation of my last post/query, My top priority is to let down the CPU usage at the Main Publisher Server, coz if the error is removed by applying...

  • RE: Error in replication

    Hi,

     

    Further more, I have same scenario, we have Merge replication 1 publication is running without any filtered (horizontal filtration) replication and works fine, but 7 publications has...

  • RE: [Microsoft][ODBC SQL Server Driver] timeout expired (#0).

    We are running our Application on Access with Backend in SQL Server since past 4 years now(there are some reasons/ features we need from access and we still use it). Initially...

Viewing 15 posts - 106 through 120 (of 125 total)