Viewing 15 posts - 4,906 through 4,920 (of 9,241 total)
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
stillconfused (9/28/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 8:29 am
GilaMonster (9/28/2012)
Rather use sys.stats, not sys.indexes. Column stats (whether manually or automatically created) aren't in sys.indexes.
yes, of course, my bad
marygrace_laurente23 (9/27/2012)
Not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 8:12 am
Check and post results of the following query
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on t.object_id = i.object_id
where t.is_ms_shipped <> 1
order by statistics_update_date...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2012 at 6:00 am
Viewing 15 posts - 4,906 through 4,920 (of 9,241 total)