Viewing 15 posts - 4,906 through 4,920 (of 9,244 total)
ananda.murugesan (10/4/2012)
I have checked at 9 AM there is no table locking and blocking that particular table...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 3:47 am
saidapurs (10/4/2012)
Hi Scogeb,Database will not go off line....
Thanks
Satish
Incorrect, if you only have the primary and the witness and the witness goes down the principal...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 1:12 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2012 at 11:50 am
To help combat sql injection ensure you assign only the required privileges to your accounts that access the database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2012 at 1:11 am
I'm still learning at the moment, caught some of it though
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2012 at 5:40 am
qew420 (10/1/2012)
1. Can I build SQL 2012 on it and migrate 2k8 to it and then get rid of 2k8
qew420 (10/1/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2012 at 2:48 am
This will display the data more accurately
selectdf.name AS LogicalFileName
, isnull(fg.name, 'Log') AS FilegroupName
, physical_name AS PhysicalOSName
, (df.size * 8 / 1024) AS SizeMBs
, case df.max_size
when 0 then 'No Growth'
when -1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2012 at 2:42 am
you would need to use the forcequorum switch, have a search for this and you'll find more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2012 at 8:24 am
Larry Kruse (9/28/2012)
I was hoping that there might be a DMV which might...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2012 at 9:48 am
Hmm, this is a difficult one as there are already some very good scripts "out there".
I'm sure others will jump in here. 1000 pages is generally the perceived point at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2012 at 5:28 am
ASFSDJG (9/29/2012)
One of my Junior DBA, Created a DB with Log file .mdf extention. can we change it with .ldf extension.
T SQL Used:
RESTORE DATABASE NewDB
FROM DISK =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2012 at 5:03 am
thotvedt (9/26/2012)
No. The SQL Server service runs under LocalSystem. Do you think that could be the problem? I wouldn't think so.
No, just want to accurately recreate your scenario.
Open up the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 12:56 pm
check the event logs for further info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 12:54 pm
stillconfused (9/28/2012)
thats kool thanks a lot... and what if we have DTS packages too
How do you intend to store your packages under 2008, filesystem, sql, SSIS?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 9:57 am
stillconfused (9/28/2012)
Can you help me with the process.
If I take backup and restore and later go with revlogin etc stuff can I be getting database objects from 2000 to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 8:55 am
Viewing 15 posts - 4,906 through 4,920 (of 9,244 total)