Forum Replies Created

Viewing 15 posts - 34,486 through 34,500 (of 49,552 total)

  • RE: Unable to attach a database

    The error's pretty clear

    robblot (1/22/2010)

    Unable to open the physical file "C:\Visual Studio 2008\Projects\LabReports Database\LabReports_log.ldf". Operating system error 5: "5(Access is denied.)".

    SQL does not have permission to access the log file....

    January 23, 2010 at 1:04 am

    #1107712

  • RE: Trigger don't run in SQL2008 but did in SQL2000 en 2005

    TheSQLGuru (1/22/2010)

    3) seems a bit recursive since it updates the table it fires from. This can get you in trouble, and I also think there is a setting that...

    January 23, 2010 at 12:55 am

    #1107711

  • RE: OLE DB Data Flow Source choking Oracle-11g

    I know, but crossposting is frowned on here and on just about every other forum there is. Best bet it to find one forum that best reflects your need and...

    January 23, 2010 at 12:54 am

    #1107710

  • RE: sql 2000 database running within sql2005

    Is there a second SQL instance or is that the only one?

    January 22, 2010 at 1:12 pm

    #1107542

  • RE: User Table size and limitations

    The maximum size of a SQL database is 524 272 TB. Somehow I don't think, with 300 rows, you need to worry about hitting that limit any time soon.

    For what...

    January 22, 2010 at 1:11 pm

    #1107541

  • RE: sql 2000 database running within sql2005

    Some clarification needed here.

    A database that's on a SQL 2005 server in compatibility mode 80 is still a SQL 2005 database. It's only that it's behaving like it was still...

    January 22, 2010 at 12:48 pm

    #1107520

  • RE: shrinking log file

    Please read through this - Managing Transaction Logs[/url]

    January 22, 2010 at 12:42 pm

    #1107517

  • RE: OLE DB Data Flow Source choking Oracle-11g

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic852243-1042-1.aspx

    January 22, 2010 at 12:41 pm

    #1107515

  • RE: Updates System Catalogs

    rudy komacsar - Doctor "X" (1/22/2010)

    Why not do it the easyway with alter database ???

    Where's the fun in that?

    :hehe:

    January 22, 2010 at 12:32 pm

    #1107507

  • RE: Parameter Sniffing

    Silaphet Mounkhaty (1/22/2010)

    Also, if I run into this issue again, I'll advise developers to modify the procedure to put WITH RECOMPILE option.

    What do you think?

    I think that's using a...

    January 22, 2010 at 12:29 pm

    #1107505

  • RE: Where are you?

    Chris Morris-439714 (1/22/2010)

    GilaMonster (1/22/2010)

    So not so much Windhoek as the Namib itself.

    Have you been there, Gail?

    No. Would like to sometime.

    Most safaris and hotels are aimed at the US/Europe market...

    January 22, 2010 at 12:28 pm

    #1107502

  • RE: Where are you?

    So not so much Windhoek as the Namib itself.

    January 22, 2010 at 7:46 am

    #1107342

  • RE: charindex or like condition

    malleswarareddy_m (1/22/2010)

    charindex( 'F3',vr_formsfilled)>0 OR charindex( 'F4',vr_formsfilled)>0

    and convert(varchar,vr_visitDate,101) between @date1 and @date2

    That is never going to perform well. i do hope fast response time is not a requirement here.

    January 22, 2010 at 7:43 am

    #1107339

  • RE: Where are you?

    Chris Morris-439714 (1/22/2010)

    I'd give several toes to visit parts of Southern Africa, including Knysna, Windhoek, the Okavango delta.

    Windhoek? Why on earth do you want to visit Windhoek? There's desert and...

    January 22, 2010 at 7:30 am

    #1107329

  • RE: Guidance needed in Indexing

    And it's only ever joined on the two columns? No filtered are ever done against other columns in this table?

    If that's the case then you probably want to put the...

    January 22, 2010 at 5:50 am

    #1107263

Viewing 15 posts - 34,486 through 34,500 (of 49,552 total)