Viewing 15 posts - 7,966 through 7,980 (of 9,244 total)
lcibert (5/12/2010)
And I cannot upgrade it because it's not supported by the application vendor for what I'm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2010 at 2:13 pm
Icibert
what version and SP of SQL Server 2005 are you using? (e.g. 9.00.1399, etc)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2010 at 12:33 pm
Hi
For SQL Server 2005 move the master first using the following
Edit the SQL server service and change the paths for the MASTER data and log files to the new location....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2010 at 12:29 pm
sqlquery-101401 (5/12/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2010 at 12:02 pm
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2010 at 3:19 am
have you rebooted after installing the hotfix?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 11, 2010 at 2:40 pm
if your looking for performance then simple DON'T use an Access front end!!
Whilst Access will process as much of the query as possible on SQL Server most times the data...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 11, 2010 at 2:37 pm
doesnt matter if you are logged onto the machine via the virtual name. You need to tell SAC manager by clicking the 'change computer' option and specifying the virtual server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 11, 2010 at 11:32 am
ah that explains things. There are a few issues with STSADM not the least the restriction on the site size. If the site is larger than 10-15 GB you may...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 11, 2010 at 3:54 am
in my experience people always elevate privileges in a vain attempt to make things work, rather than sit down and work out what is required!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 10, 2010 at 7:57 am
ensure the IP address you specify for the SQL Cluster instance is unique. You will need to provide more details of the settings you are specifying during install. Have you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2010 at 6:04 am
JC-3113 (5/7/2010)
I understand that they need DBO privilege to do the exports and imports.
what makes you think that??
if they are importing data and the database objects already exist...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2010 at 3:13 pm
they should already be set for you but there is no harm in checking them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2010 at 2:55 pm
K. Brian Kelley (5/3/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2010 at 2:48 pm
specifically, ensure you run DBCC UPDATEUSAGE against the database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2010 at 11:10 am
Viewing 15 posts - 7,966 through 7,980 (of 9,244 total)