Viewing 15 posts - 8,896 through 8,910 (of 9,248 total)
sunshine (9/15/2008)
the previous statement must be terminated with a semicolon.
this message is fairly descriptive!! The USE statement and exec must be separated by a semi colon like so
SELECT @execmd =...
September 16, 2008 at 5:22 am
also, SQL2005 is able to address as much RAM as the NOS will allow 😉
September 15, 2008 at 1:38 pm
Ninja's_RGR'us (9/15/2008)
Like I tested it and in this case exists is faster than in?
thats what i'm asking
September 15, 2008 at 10:33 am
Dana Bibeault (9/15/2008)
Can I install Windows Enterprise and run SQL 2005 Standard Edition?
that will be just fine, you'll need Enterprise edition of Windows server to address the extra RAM as...
September 15, 2008 at 10:30 am
Hi
i'm contracting at present, checkout Jobbserve and you'll see plenty of SQL opportunities both home and abroad
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.
September 11, 2008 at 3:53 pm
Grant Hoerz (9/11/2008)
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 😉
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
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...
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 😉
September 9, 2008 at 5:50 am
do you mean specifically tape devices or just logical backup devices?
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...
September 8, 2008 at 4:14 pm
what version sql server are you using?
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...
September 8, 2008 at 4:07 pm
Viewing 15 posts - 8,896 through 8,910 (of 9,248 total)