Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 1,047 total)

  • RE: handelling of IDENTITY Column in a Table

    I'm sorry to hear that your data is screwed up like that, probably because you have different prices for different quantities of a product from the same supplier. This is...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: handelling of IDENTITY Column in a Table

    naginderp (8/3/2009)


    Thanks for ur reply again

    There is dupliecate data like same supplier and productcode have been repeated , there are another coplumns that are hidden , i acn not...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds

    Another thing that can cause this is insufficient memory, or improperly allocated memory. If the server is doing a lot of paging I/O it will impact performance, especially of your...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Questions about db_owner role.

    Perhaps your co-worker is not logging in with that user id and password. He might be connecting with integrated security.

    Why don't you log in yourself with that user and password...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: SQL login failure

    If that IP is the SQL server IP then it is a process executing on the local SQL Server box. Possibly a schedule task? Or maybe your server is infected....

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: SQL login failure

    If the IP address is coming from a gateway, proxy server or webserver then its harder, otherwise that IP is the machine trying to log in. If its from...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Store procedures

    I've always found the text in syscomments.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: copy encrypted(Binary Data) values from one database to another database

    backup and restore the database master key to the destination database. Depending on the encyrption methodology you might have to restore the service master key to the destination server.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: New distribution server on SQL 2K5 Transaction Replication

    you'll have to drop the subscription and resubscribe to the publications.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: How to use 'C#' in a sql 'where' statement ?

    are you really using double quotes for your varchar constants? You should be using single quotes.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Table partitioned on date

    before you move to a partitioning solution you should look at the table design and the reasons why the table is getting so big or your performance is getting poor....

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Sending emails

    You said your mail server is configured for sending up to 10Mb attachments. Maybe you need to send this email reports as an attachment (i.e with MIME encoding) as opposed...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: Best Way to Implement MultiServer Admininstration Redundancy?

    I'm not quite sure what you mean by "multi server admin". DO you mean the method in which you log on to each server and perform admin duties like...

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: trigger to email based on column update

    there is no "updated" table that I'm aware of. All you have for triggers is inserted and deleted tables.

    The probability of survival is inversely proportional to the angle of arrival.

  • RE: EXEC sp_execute

    'proof' was probably too strong a word. (The only injection proof server is one with no connections. lol)

    The probability of survival is inversely proportional to the angle of arrival.

Viewing 15 posts - 1,006 through 1,020 (of 1,047 total)