Viewing 15 posts - 1,006 through 1,020 (of 1,047 total)
Put those audit columns in a separate table. Each row would have a date_time, a userID and a type (create, updated etc.) and a column (ID probably) to link back...
August 3, 2009 at 10:56 am
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...
August 3, 2009 at 8:51 am
naginderp (8/3/2009)
There is dupliecate data like same supplier and productcode have been repeated , there are another coplumns that are hidden , i acn not...
August 3, 2009 at 8:35 am
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...
July 31, 2009 at 8:23 am
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...
July 28, 2009 at 9:36 am
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....
July 28, 2009 at 9:21 am
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...
July 28, 2009 at 9:00 am
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.
July 27, 2009 at 1:52 pm
you'll have to drop the subscription and resubscribe to the publications.
July 22, 2009 at 12:15 pm
are you really using double quotes for your varchar constants? You should be using single quotes.
July 21, 2009 at 9:17 am
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....
July 21, 2009 at 8:50 am
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...
July 20, 2009 at 11:16 am
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...
July 9, 2009 at 12:41 pm
there is no "updated" table that I'm aware of. All you have for triggers is inserted and deleted tables.
July 9, 2009 at 12:34 pm
Viewing 15 posts - 1,006 through 1,020 (of 1,047 total)