Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,109 total)

  • RE: i want to prevent a user to login to enterprise manager

    steevlee (9/28/2007)


    hi friends..

    i want to prevent a user to login to enterprise manager but to allow that user to use in connetion string for connecting to database through the program...

  • RE: language compatability

    sreedhar (9/28/2007)


    Thanks for the quick reply.

    Had one more point to clear

    If the language of the Operating system is in English and the website and sqlserver is in French.

    will i face...

  • RE: Table Size

    SreenivasReddy (9/28/2007)


    Hi,

    One of my table is having around100 columns and most of which are Numeric, NULL. Out of 100 columns only 10 columns are having data and others are null....

  • RE: audit data change, before and updated value

    Louis Lam (9/27/2007)


    Hi all,

    Anyone know of any way in SQL Server that allow me to find record value before and after update value for auditing purpose. I know it...

  • RE: language compatability

    sreedhar (9/28/2007)


    i had a website in french language developped in asp.net and sqlserver2005. is it possible to use sqlserver 2005 english version to deploy the website

    will i get struck at...

  • RE: SQL Server login

    steevlee (9/28/2007)


    hi friends..

    i want to prevent a user login to enterprise manager but to allow that user to use in connetion string for connecting to database through the program (c#)....

  • RE: Database user and Corresponding login

    LAravind (9/27/2007)


    Hi everyone,

    I have a simple question regarding the database users on sqlserver 2005.

    When i run a 'sp_helpuser' stored procedure in a database to know the usernames and their...

  • RE: Identity Value missing -- SQL 2000

    arj (9/27/2007)


    Hi,

    Thank you for the clarification given. It helps me to give a report to my superiors...

    Could any one please tell me how to track the DML operations occuring on...

  • RE: How to obtain sqlserver 2005

    P (9/26/2007)


    Hi,

    I could not access the DVD drive from the remote server.

    Is there any option to download the SQL Server Enterprise Edition, if I purchase the DVD (license?) properly from...

  • RE: SQL to list technicians and traffic controllers

    zim (9/26/2007)


    Query(a report) to list the technicians/traffic controllers separately with following details.

    EmployeeId,Name,Salary,Address,UnionId, and the most recent medical examination date for traffic controllers

    Employee (EmployeeId(p),Name,Salary,Tpye).

    MedicalExamination(MedicalNo(p),EmployeeId,MedicalDate)

    EmployeeUnion(EmployeeId(p),UnionId(p))

    "Type" field in Employee table tells whether...

  • RE: Unusually large backup size of transaction log?

    Jo Pattyn (9/26/2007)


    The reindexing isn't a bulk operation.

    I would try to make extra transactionlog backups during the indexing to keep the size small

    I agree with Jo,

    indeed, switching to bulk recovery...

  • RE: Needs help on backups.

    I'd look at third party data comparison tools that will show you the exact differences. These tools will also help you to migrate those differences in data. I assume the...

  • RE: Insert image file in an IMAGE column

    ArthurC (9/25/2007)


    Hi there,

    How to use an INSERT statement to insert an image file in an IMAGE data type column?

    Thanks,

    AC

    If you want to use SQL, have a look at the thread:...

  • RE: Tracking users to SPIDS in logs

    Have you got anything in your default trace (SQL Server 2005 has a trace running by default that keeps track of certain operations, among others sp_configure excutions if the confuguration...

  • RE: how to delete a backup set?

    Martin Brice (9/24/2007)


    Does that mean the only way to delete the backup set is to turf the entire thing?

    AFAIK this is the case, i.e. you would need to delete the...

Viewing 15 posts - 856 through 870 (of 1,109 total)