Viewing 15 posts - 4,756 through 4,770 (of 9,249 total)
Marios Philippopoulos (10/18/2012)
All you have to do is go through each log in turn and try to delete it.If it is in use, it will not let you.
That's a pretty...
October 18, 2012 at 8:23 am
dinsab11 (10/18/2012)
when u right click on server's name in SSMS. i see different name and when i run select @@servername find different name.
Please see my post above
October 18, 2012 at 8:19 am
glad you got it resolved, DBCC LOGINFO is your friend here 😉
October 18, 2012 at 3:48 am
GilaMonster (10/18/2012)
Steve edits them, don't know what his process is.
I'm guessing he didn't edit that one, it was way off base 😉
The last time someone was that wrong, Adolf Hitler...
October 18, 2012 at 3:42 am
sej2008 (10/17/2012)
in workgroup environment using administrator as a user and password of principal,mirror and witness servers is the same.
Endpoint are different...
October 18, 2012 at 1:19 am
Vegard Hagen (10/17/2012)
The version number in the file properties (and in server properties inside Management Studio) lets you know exactly what...
October 17, 2012 at 11:50 pm
Yes, it's SQL Server 2005 SP3
October 17, 2012 at 2:34 pm
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...
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...
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'
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???
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...
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...
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....
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...
October 16, 2012 at 1:45 pm
Viewing 15 posts - 4,756 through 4,770 (of 9,249 total)