Viewing 15 posts - 8,896 through 8,910 (of 9,244 total)
Hi
i'm contracting at present, checkout Jobbserve and you'll see plenty of SQL opportunities both home and abroad
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 10:24 am
Steve
check with Esri but i'm sure changing the logical filenames will make no difference. The SDE database will be referenced by the database name only not by logical filename.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2008 at 3:53 pm
Grant Hoerz (9/11/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2008 at 3:42 pm
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
Viewing 15 posts - 8,896 through 8,910 (of 9,244 total)