Viewing 15 posts - 2,116 through 2,130 (of 7,498 total)
Digs (4/20/2011)
MSSQL 2008 R2 vs MSSQL 2008 R2 Express1) what is R2 anyways?
Have a look at http://msdn.microsoft.com/en-us/library/cc645993.aspx
2) Whats the difference btw the two, TSQL, variables, tables other database objects??
Books online...
April 20, 2011 at 4:00 am
please provide full error information ( sqlserver errorlog )
April 20, 2011 at 3:52 am
Brandie Tarvin (4/19/2011)
April 20, 2011 at 1:45 am
Koen Verbeeck (4/19/2011)
ALZDBA (4/19/2011)
( altough it reminds me of a great song some decades ago by The Clash [howling]x6 )
Thanks, this will be stuck in my head for the...
April 19, 2011 at 1:06 am
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
My bank account is crying so loud, I can't even hear London calling ....
( altough it reminds me of a great song some...
April 19, 2011 at 12:40 am
Stefan Krzywicki (4/18/2011)
ALZDBA (4/18/2011)
I used the open source :blush: 7zip free solution. ( I don't know if RAR is actually free)
It is...
April 18, 2011 at 7:52 am
Does Zip still have the 4GB limit ? :ermm:
I used the open source :blush: 7zip free solution. ( I don't know if RAR is actually free)
It is able to compress...
April 18, 2011 at 7:27 am
john.daisley (4/15/2011)
ALZDBA (4/15/2011)
OP stated
"I have 32 bit Windows server 2003 with memory of 8 GB"
The URLs I provided explain the RAM sizes and 3gb/pae combinations to be used.
@ALZDBA -...
April 15, 2011 at 7:48 am
is this your first alert ?
Did you restart sqlagent after installing the alert ?
April 15, 2011 at 7:26 am
john.daisley (4/15/2011)
ALZDBA (4/11/2011)
If you want your instance to use more than 1.7GB RAM, you'll need to do two actions:
1) add...
April 15, 2011 at 7:19 am
your instance has a number of connections to be able to run (for system processes)
These are mostly connected to master
in sys.processes system processes will have a number lower than...
April 15, 2011 at 3:44 am
Very valid questions, but since you are planning on moving database files, (parts of ) your db will be offline for a while (to be able to actually move the...
April 15, 2011 at 3:12 am
I tested this script:
USE [msdb]
GO
/****** Object: Alert [DBA_LockingTreshold] Script Date: 04/15/2011 08:30:59 ******/
IF EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'DBA_LockingTreshold')
EXEC msdb.dbo.sp_delete_alert @name=N'DBA_LockingTreshold'
GO
EXEC msdb.dbo.sp_add_alert...
April 15, 2011 at 2:09 am
"after" is always to late.
We create windows groups for that get the needed access auth on our dev instances. A devs login will only need to be added to that...
April 15, 2011 at 12:18 am
Viewing 15 posts - 2,116 through 2,130 (of 7,498 total)