Viewing 15 posts - 9,166 through 9,180 (of 9,241 total)
Ratheesh
i would install SQL2005 developer alongside as a separate instance.
move databases, logins, etc to the new instance.
remove the old one when finished.
script the logins off using the MS script at
http://support.microsoft.com/kb/246133
detach...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 3:15 am
i'm using Redgate SQL Backup v5.x, its a great product offering good speed and very high compression. It also gives us 256bit encryption which we need for our backups. Very...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 4:29 pm
hi yes you can move the files and also add new files
First set the database offline.
Copy the current disk files to the new location.
Use the "ALTER DATABASE MODIFY FILE"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 3:50 pm
at the end of the day SQL Server is just another application, the OS is the fundamental part of the equation. Every DBA whether Oracle\SQL\etc should understand and be able...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 3:45 pm
Jay Murthy (7/16/2008)
declare @val1 varchar(25),@VAL2 varchar(25)
SET @val1 = ''
SET @VAL2 = 'W'
If 'W' In(@val1,@VAL2)
Begin
PRINT...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 11:05 am
yes, its under HKLM\SYSTEM\currentcontrolset\services but i find a WMI query easier personally
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 10:06 am
here you go try this, reports database name, logical filename and log file locations for all databases on an instance
select a.name, b.name as 'Logical filename', b.filename from sys.sysdatabases a
inner...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 9:53 am
do you have any databases you want to keep?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 9:34 am
sqluser (7/16/2008)
Hi Perry,Could you please elaborate more for the same?
---
open the services console from administrative tools and check the sql service properties. A default instance will have the service name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 4:40 am
check this link
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
as for cost, who do you normally purchase licences from ?
Give them a call and get a quote would be best?
Basically Ent allows online indexing , max CPU...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 2:19 am
check the services.msc console or enumerate through code
a default installation of SQL server will have the following service name
MSSQL$SERVER
for a named instance it will be
MSSQL$instancename
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 2:03 am
a.thomson2 (7/15/2008)
CREATE PROCEDURE@EmailTo nvarchar(250)
AS
BEGIN
SET NOCOUNT ON;
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'VoiceSQLMail',
@recipients = @EmailTo,
@body = 'Testing';
END
is this a typo, your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2008 at 1:57 am
GilaMonster (7/14/2008)
I know. That's why I wrote the blog post in the first place, so I didn't have to keep on explaining why shrinking is bad.
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2008 at 4:28 am
ungmax
it would be helpful for everyone including yourself if you didnt hijack someone else's thread. Best to start your own you probably get more response that way
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 4:14 pm
double check spelling of domain\username
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2008 at 4:07 pm
Viewing 15 posts - 9,166 through 9,180 (of 9,241 total)