Viewing 15 posts - 2,401 through 2,415 (of 2,840 total)
It all depends on what right you have and how you set up your account as the SQL Server account. If you use the SQL Configuration tool to set your...
February 18, 2009 at 10:42 am
Sorry , My bad. It is Create_procedure. You can see more detail in BOL.
February 18, 2009 at 9:00 am
That depends on the rate of growth and the number of transactions it handles. If it is a High Transactional DB, then 500 would be better since it does not...
February 18, 2009 at 8:41 am
If you are using SQL 2005 (I assume you are) you can look at DDL Triggers.
CREATE TRIGGER AuditProc
ON DATABASE
FOR CREATE_PROC, ALTER_PROC, DROP_PROC, CREATE_TABLE, ALTER_TABLE, DROP_TABLE
AS
DECLARE @event XML
SET @event = EVENTDATA()
INSERT...
February 18, 2009 at 8:39 am
My recommendation would be not to let it Autogrow. It is better to do it manually. Keep a monitor in place to find out if it is nearing the threshold...
February 18, 2009 at 8:27 am
The only other option I see is Bulk Copy.. And that is nasty as well.. 🙂
February 18, 2009 at 8:14 am
You can always check the eventvwr to see what the error was. Please post what you see in the eventvwr
February 18, 2009 at 8:09 am
For me this is how it goes... I at first had problem with BOL, because the functions were different from Oracle. So it was frustrating. Now I have the knowledge...
February 18, 2009 at 6:30 am
First the question is not so clear. So the answer might be a bit distorted. From what I understood, the last part what you want to do is a Conditional...
February 17, 2009 at 8:06 am
As soon as you delegate H to be the Primary, start taking transaction log back ups. Once you move the server to B, start restoring the transaction logs. Before the...
February 17, 2009 at 6:48 am
In another section of this Forum (SSC) there is a thread about mySpace.com and how they are using the SQL Servers. Maybe you can take look at it to understand...
February 17, 2009 at 6:25 am
Calm down people ... Calm down...:D It is a Monday afternoon...:D Not the best day to have arguments.... 😉
February 16, 2009 at 1:54 pm
I know for a fact that Oracle will loose in a MS SQL Forum... But these many people against it ??:unsure:
February 16, 2009 at 10:27 am
Great Article. I have added to my Breifcase. Like everyone said, I hope I never have to use it.. 😀
February 16, 2009 at 8:02 am
You can use Locking Hints (ROWLOCK). Check BOL for more details. But it is advised that you should let SQL Server itself manage the Locking.
February 16, 2009 at 7:00 am
Viewing 15 posts - 2,401 through 2,415 (of 2,840 total)