Viewing 15 posts - 361 through 375 (of 965 total)
Make sure you have instant file initialization enable:
http://www.sqlskills.com/blogs/paul/2008/08/11/HowToTellIfYouHaveInstantInitializationEnabled.aspx
Then create a method of monitoring your database file available space so that you get an alert or email to let you know...
May 18, 2009 at 8:16 am
2 Tim 3:16 (5/18/2009)
I believe (could be wrong) at least 2-3gig (based on boot.ini) is set aside for the os in the kernel.
The VAS split is specific to...
May 18, 2009 at 7:40 am
Florian Reischl (5/15/2009)
May 18, 2009 at 7:24 am
This is telling you that the mail server is rejecting your request to send email. Check firewall settings between the two servers, and then check to see if your...
May 18, 2009 at 7:18 am
I personally use the code on Ola Hallengren's blog for newer servers or when I am consulting. It is very well written and extremely flexible.
May 18, 2009 at 7:07 am
It looks like your XML from the web.config didn't make it, possibly because you didn't tag it inside of blocks correctly.
May 18, 2009 at 7:04 am
over linked servers it should still work you just have to use ... for the DMV's so with a link named Development, and the AdventureWorks Database it would be Development.AdventureWorks.sys.objects....
May 13, 2009 at 10:59 pm
You could try doing it by hand using a query similar to the following:
select o.name as TableName,
i.name as IndexName,
(
SELECT c.name + ', '
FROM sys.index_columns ic
JOIN sys.columns c ON...
May 13, 2009 at 7:25 pm
Your SQL Service Account would need to have the necessary rights in the OS to allow it to run this. It isn't based on the user calling xp_cmdshell, its...
May 13, 2009 at 11:43 am
It is the same direction that Gail was sending you. I've had to get myself out of a jamb in the past where I removed BuiltIn\Admins before putting my...
May 13, 2009 at 9:21 am
The benefit is that you don't have a passive node just sitting there waiting for a failure. The downside is you don't have a passive node just sitting there...
May 13, 2009 at 7:54 am
Florian Reischl (5/13/2009)
Usually your application connects with windows credentials of the current connected user to connect to database.
If you want to use windows authentication but connect with another user you...
May 13, 2009 at 7:52 am
Redgate to date has been really good at supporting their products, so I'd give that a shot if you are having a particular problem with something. It is in...
May 13, 2009 at 7:48 am
If you are a local Administrator in Windows on the SQL Server server, you can start the service in single user mode with the -m parameter and any local administrator...
May 13, 2009 at 7:39 am
That would probably depend on your phone brand and type. I am sure your local wireless dealer could probably tell you how to configure it properly if it could...
May 13, 2009 at 7:34 am
Viewing 15 posts - 361 through 375 (of 965 total)