Viewing 15 posts - 4,756 through 4,770 (of 9,241 total)
ok, the path shown is atypical of a SQL server 2005 installation. Confirm this by browsing to the sqlservr.exe and open the file properties, on the version info check the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 2:16 pm
JimS-Indy (10/17/2012)
Binary install path???
Asked myself the same question. Is it on the properties sheet and I missed it? I looked.
find the service name in services.msc and right click then select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 11:46 am
Have you renamed the Windows server since sql server was installed?
To remove the current servername entry use
exec sp_dropserver 'abcxyz'
Then run this to correct it
exec sp_addserver 'abcdef', 'local'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 11:41 am
JimS-Indy (10/17/2012)
Note Capture 5 -- SQL Server Configuration Manager.Capture 6 -- Server Manager.
Binary install path???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 7:48 am
JimS-Indy (10/16/2012)
See Capture 4
well, according to the output you only have one instance of SQL Server and it's a default instance. Go into services.msc and right click the service
SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 4:53 am
Its still not clear what you want to do.
Which version\edition of the Windows OS do you plan to use for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 4:03 am
Books online states that if no target size is specified, a shrink-file operation removes only the inactive virtual log files beyond the last active virtual log file in the file....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 3:07 pm
Really need to get an idea of the current file sizes, post the results of this please run against your database
USE YourDB
GO
selectname
, size / 128 AS FileSize
, case max_size
when -1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 1:45 pm
kkanaya (10/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 12:58 pm
Number of indexes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 12:56 pm
open a cmd prompt on the machine and post the output of
NET START
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 12:12 pm
david.washington (10/16/2012)
Great article.
just out of interest which article were you reading?
Paul Randal (10/16/2012)
My goodness - what a load of utter nonsense in this article.
I actually didn't want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 11:58 am
Litespeed is a packaged installer which installs the binaries.
You then need to launch the Litespeed configuration wizard, you could check with Quest if there is a way to script this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 9:10 am
configure what exactly?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 8:43 am
Marios Philippopoulos (10/16/2012)
I will probably not do that, as it seems a bit too much voodoo to me... 🙂
Whats voodoo about creating a table, inserting some records and truncating...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 8:21 am
Viewing 15 posts - 4,756 through 4,770 (of 9,241 total)