Viewing 15 posts - 8,896 through 8,910 (of 9,241 total)
Christian Buettner (9/8/2008)
Hi Perry, could you please post an example?
why?
that's what i'm asking you 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2008 at 9:43 am
MANU (9/9/2008)
Locking pages in memory is not required on 64-bit operating systems.MJ
hmm, i read that 64 bit SQL2005 standard doesnt support this and 64 bit sql2005 Ent requires it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2008 at 9:41 am
Sandra Skaar (9/9/2008)
i.e. physical file name is ORN1_data and ORN1_log)
they certainly look like logical file names too.
you can and i would change the logical file names using the
alter database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2008 at 12:00 pm
Jeff Moden (9/9/2008)
Or, you could do it the way I showed you and not worry about correlation. 😉
even better 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2008 at 5:50 am
do you mean specifically tape devices or just logical backup devices?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2008 at 5:47 am
Brian.Dunat (9/3/2008)
2. Modify Group Policy to ensure service accounts have the proper rights (ie: logon as service, etc)3. Add the service accounts to the necessary local groups on the server
SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 4:14 pm
what version sql server are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 4:09 pm
siweb (9/4/2008)
select value from table
where name = 'DateTime'
and IsDate (value) = 0
And no rows return. This should indicate that all the string values is recognized as a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 4:07 pm
SQL server 2005 std requires installing to a server OS not a client OS, for clients use developer or Express
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:59 pm
blom0344 (8/20/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:55 pm
where exists
would be more efficient than
where in
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:46 pm
you;ll need to move the data files over first and attach them to the server. Then you create the extra filegroups. Then create\move objects into those filegroups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:28 pm
WMI, much easier 😎
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM Win32_LogicalDisk where drivetype=3",,48)
For Each...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:25 pm
in this scenario the best way to analyse the log status is using
dbcc loginfo
look at the status column and they should ideally be 0. The further down you scroll...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:21 pm
GilaMonster (9/8/2008)
Make sure that the account has full control over the directories that have your data and log files in, and also the directories that the backups go.
this shouldnt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2008 at 3:17 pm
Viewing 15 posts - 8,896 through 8,910 (of 9,241 total)