Viewing 15 posts - 9,181 through 9,195 (of 9,248 total)
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...
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...
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
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...
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.
😉
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
July 14, 2008 at 4:14 pm
double check spelling of domain\username
July 14, 2008 at 4:07 pm
do you have a firewall enabled?
if so check the firewall log
July 14, 2008 at 10:38 am
ALZDBA (6/16/2008)
If you license an instance on a physical server, you license per cpu socket.
With virtual servers, you license per available cpu (i.e. cpu-core...
July 14, 2008 at 10:34 am
some brilliant links and advice there, way to go guys 😀
July 14, 2008 at 10:01 am
this shrinking malarky has been done to death all over the forum:D
good job cos i learnt something new 😉
July 14, 2008 at 10:00 am
from memory, (forgive the pun) Windows 2003 server Enterprise shouldnt need a /PAE switch.
July 14, 2008 at 9:56 am
GilaMonster (7/14/2008)
ltoso (7/11/2008)
There should be a firewall. A web-facng server without a firewall is just asking for various forms of trouble.
that's the thing that worried me, how can public ip's...
July 14, 2008 at 9:53 am
check this link
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1721211&SiteID=1
it may be of some use
July 13, 2008 at 3:49 pm
are you sure you wanteed to audit all tables, that is quite an overhead to place on the database.
July 13, 2008 at 3:41 pm
Viewing 15 posts - 9,181 through 9,195 (of 9,248 total)