Forum Replies Created

Viewing 15 posts - 361 through 375 (of 965 total)

  • RE: SQL Server autogrow timeout

    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...

  • RE: SQl Server 2005 Clustering

    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...

  • RE: CLR Funtions

    Florian Reischl (5/15/2009)


    Yep. File management is also a nice approach done by CLR. Another one is all those OLE-Automation things instead of sp_OACreate. Hube binary conversions or network conversations like...

  • RE: Database mail

    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...

  • RE: Rebuild/Reorganize index script

    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.

    http://blog.ola.hallengren.com/

  • RE: Number of Logins in sleeping status....!!!

    It looks like your XML from the web.config didn't make it, possibly because you didn't tag it inside of blocks correctly.

  • RE: Compare indexes between two databases

    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....

  • RE: Compare indexes between two databases

    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...

  • RE: Using Contig to defrag files

    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...

  • RE: there is no sysadmin

    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...

  • RE: SQl Server 2005 Clustering

    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...

  • RE: SQL Server 2005 username/password validation

    Florian Reischl (5/13/2009)


    Hi

    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...

  • RE: Best way to copy data?

    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...

  • RE: there is no sysadmin

    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...

  • RE: CALL PHONE from SQL Stored PROC/ Alerts

    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...

Viewing 15 posts - 361 through 375 (of 965 total)