Viewing 15 posts - 8,506 through 8,520 (of 9,241 total)
as well as the version get the following
select @@servername, serverproperty('servername')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:45 am
it seems you have 2 instances referencing COW0, my guess is you upgraded the wrong one hence why you see the sql2000 version number. Are the 2 extra instances MSDE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:31 am
yes just seen the COW0 instance in the registry too. Scroll across to the right on the right hand pane, what are the installed instances?
what instance name are you typing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:28 am
so besides the 2 default desktop engines you have an instance
MSSQL$COW0, what instance are you logging into via SSMS?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:23 am
Todd Engen (1/8/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 9:35 am
presumably you have access to the source for the CLR functions you are to migrate?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 7:36 am
kiransuram19 (1/16/2009)
I took backup of the customterDB(using Litespeed) and the .bak file size is 15.6MB..
what compression were you using within Litespeed?
on a database that contains a lot of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 4:49 am
SBS installs 2 desktop engine instances. One for Sharepoint and one for SBSMonitoring.
Can you post a registry screenshot of the following key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 4:27 am
RPSql (1/12/2009)
I have one issue..I have server A and Server B. Now on Server B my sql server agent is disabled. I have setup a maintenance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 3:46 am
check your column data types, growing 8GB in 3 years doesnt seem too wrong depending on the data you are storing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2009 at 3:39 pm
piece of advice, dont screw with MSDB if you must backup the database first.
apart from that, 335 MB isnt too bad but i noticed the job history table is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2009 at 3:25 pm
Tracey
remember the path for the resource db data and log file must be the same as the master.mdf
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2009 at 11:01 am
SQL_Quest
what version of ArcGIS are you using?
The spatial layers are part of the ArcSDE engine. You can use direct connect to connect to the database from the SDE engine...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2009 at 10:18 am
most updates affect the system databases, i dont think an un install would not be a viable option, although nice too have. An un install would have to tie in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2009 at 6:13 am
colin Leversuch-Roberts (1/12/2009)
see what a hornets nest this stirs up.
you're not wrong there sir. A great thread going on here!
who will win the speed war copper or fibre...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2009 at 4:02 pm
Viewing 15 posts - 8,506 through 8,520 (of 9,241 total)