|
"Cannot insert duplicate key" error on UPDATE, WHAT????
|
| |
Hi Everyone, I just setup a few thing on the tables in this database so that no one can delete records. And I just noticed today that a proc I have does not work correctly. I just added this trigger (no others exist for this table): CREATE TRIGGER [DontDeleteATTENDANCE] ON [dbo].[ATTENDANCE] Instead of DELETE... more »
|
|
|
Quad core and SQL 2005 standard
|
| |
Since SQL Server 2005 standrad edtion only support 4 CPU's, does that mean it will only use 1 x quad core processor? If I have 2 x quad cores can't is use all 8 cores?
|
|
|
Is there anyway to script multiple tables to one file?
|
| |
I have various tables and stored procedures that I need to port to another server. So I have to script each one out to a file or to the clipboard. Is there any way to script each one so that each new one appends to a file instead of creating a new file every time? When I create multiple files, I have to cut and paste to put them into one... more »
|
|
|
Setting up AWE
|
| |
Hi.. I'm trying to set up AWE in a Server with 8 GB of RAM, Windows 2003 Enterprise and SQL 2005 Standard my Boot.ini is like this: [boot loader] timeout=30 default=multi(0)disk(0)rdisk(0 )partition(1)\WINNT [operating systems] multi(0)disk(0)rdisk(0)partiti on(1)\WINNT="Windows Server 2003, Enterprise"... more »
|
|
|
Event 28005 flooding App log
|
| |
This event is flooding the app log.. any ideas on how to stop it? Event Type: Error Event Source: MSSQL$OPSMGR Event Category: (2) Event ID: 28005 Date: 5/22/2008 Time: 11:54:41 AM User: N/A Computer: CLTSCOMSQL1 Description: An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal... more »
|
|
|
Monitoring tool
|
| |
Our environment is getting bigger and bigger. We have almost 45 SQL Servers running and its a high availability cluster servers. We need to monitor all jobs, services etc. Is there any third party monitoring tool that can monitor all services and SQL jobs? Farrukh
|
|
|
Identify that database is enabled for logshipping in sql2k5 sp2
|
| |
Is there a way to query any dynamic view or system table to see if a database has log shipping enabled? I belived it should be in databaseproperty or databasepropertyex but I can'tr find it. My purpose is to handle these databases in a different way when building up dynamic transaction log backup job.... more »
|
|
|
Break in communication ?
|
| |
hi all - wonder if there is anyone out there who experiances what i am experiancing? i run sql server 2005 on a machine with windows server 2003. very small database collecting radius accounting data for about 40 adsl users. the server has 2 gig ram on a 3ghz dual core machine 180gig drive space on a raid 10 array and i constantly het the follwing error in the error... more »
|
|
|
