Forum Replies Created

Viewing 15 posts - 691 through 705 (of 859 total)

  • RE: SQL Server 2005 long running queries.

    *vivian* (2/8/2010)

    Dear All,

    Thanks in advance for your help:-)

    We have a SQL Server 2005 standard server,

    server RAM is 4GB, and SQL Server is configured with Minimum server memory: 2000MB, Maximum...

    February 8, 2010 at 4:57 am

    #1115392

  • RE: SQL error -Statement(s) could not be prepared.

    sanjanajax,

    See the following MS KB:

    http://support.microsoft.com/kb/936223

    http://support.microsoft.com/kb/915074

    February 2, 2010 at 9:32 am

    #1112368

  • RE: How to get the Job Status in Query

    haichells (1/25/2010)

    Hi,

    Can anyone please help me the query to get the Status of Jobs in a server.. i.e for ex Job A - Executing ,Job B- Failed ,Job C -...

    January 25, 2010 at 10:59 am

    #1108291

  • RE: INDEX DEFRAGMENTATION SCRIPT

    D Rose (1/22/2010)

    I see in the SQL that this is for SQL 2005 +.

    Is this possible on SQL 2000?

    Thanks!

    Defragmentation script only works for sql server 2005/2008.If u want u can...

    January 24, 2010 at 4:19 am

    #1107900

  • RE: INDEX DEFRAGMENTATION SCRIPT

    Alex Gay (1/22/2010)

    Quick bug fix.

    The line "EXEC ('USE '+@DB_NAME+';"

    Should be "EXEC ('USE ['+@DB_NAME+'];"

    otherwise it fails if you have a database name with spaces in.

    Not that any of us would...

    January 24, 2010 at 4:16 am

    #1107899

  • RE: Info on Latest service Pack.

    mukisql2008 (1/22/2010)

    Can you provide info Latest service pack for SQL Server 2005 & 2008 ?

    The best answer is google.

    January 23, 2010 at 12:01 am

    #1107701

  • RE: disk size

    ramyours2003 (1/22/2010)

    i want to determine the disk sizes whether to increase or not . as we are facing the backup jobs failed due to low disk space . on...

    January 22, 2010 at 8:34 am

    #1107392

  • RE: RE:Log Shipping

    tkatende (1/21/2010)

    hello there am new to sql 2005 and i would like to know if i can do log shipping on one computer with two instances. One instance acts like...

    January 21, 2010 at 5:02 am

    #1106607

  • RE: sql server 9.0.3033

    k.solai 53753 (1/21/2010)

    HI All,

    I am creating the database configuration document , i want to know sql server 9.0.3033 about this, and help what are points needs to be add...

    January 21, 2010 at 4:35 am

    #1106594

  • RE: The new path will be used the next time the database is started.

    Shivrudra (1/21/2010)

    Hi All,

    I have created a Test database on E:\sql drive by Sql server 2005 Express edition successfully,

    but when i modified the data file from E:\SQL to E:\ the following...

    January 21, 2010 at 4:32 am

    #1106593

  • RE: backup job details

    ramyours2003 (1/19/2010)

    i want to find thebackup job details i.e at what time the backup is scheduled and type of backup job and whether it is type...

    January 19, 2010 at 6:15 am

    #1105371

  • RE: Is it possible to keep my database in RAM????

    Saravanan T (1/18/2010)

    Is it possible to keep my database in RAM????

    I agree with Chris Morris.You need to give more info.

    January 18, 2010 at 7:46 am

    #1104938

  • RE: Question On Indexing

    WilliamBendall,

    Please read the Grant Fritchey's article about execution Plan [/url]

    January 13, 2010 at 7:45 am

    #1103052

  • RE: Question On Indexing

    --Query 2

    select *

    from bo_fin_history

    where account = '00000000008000002422101'

    Hi,

    Ur second query ll not take the C.I index "Ix_join"

    See the execution plan the optimizer took the index "Ix_post" that y the key...

    January 13, 2010 at 7:24 am

    #1103037

  • RE: space issue

    ramyours2003 (1/12/2010)

    we created a maintainence plan for backup and clean up job to remove the old backups more than 4 hrs as we r facing the disk space...

    January 13, 2010 at 7:11 am

    #1103023

Viewing 15 posts - 691 through 705 (of 859 total)