Forum Replies Created

Viewing 15 posts - 76 through 90 (of 201 total)

  • RE: transfering users from one db to another

    Steve Jones - Editor (7/28/2008)

    sp_change_users_login is a way to sync logins to users.

    If you are moving databases, typically you move the logins once, then each time you restore, you might...

    July 28, 2008 at 11:05 pm

    #849561

  • RE: DTS packages

    Greg Charles (7/28/2008)

    I found this in the script section, but I haven't used it.

    http://www.sqlservercentral.com/scripts/Miscellaneous/31613/

    Thanks Greg..but this didnt work 🙁

    July 28, 2008 at 11:00 pm

    #849560

  • RE: Error log

    Thanks Steve,

    ===================================================================== ...

    July 28, 2008 at 6:28 am

    #849118

  • RE: Error log

    steveb (7/28/2008)

    Have a look at the error log in SSMS , under Management --> SQL Server Logs, and see what errors that has thrown, this should give you better...

    July 28, 2008 at 5:18 am

    #849080

  • RE: transfering users from one db to another

    bodhilove (7/27/2008)

    Hi Folks,

    I believe there is a way to transfer db users and logins in sql server using Business Intelligence or SSIS. Does anyone know of any articles to outline...

    July 27, 2008 at 11:03 pm

    #848957

  • RE: Database Growth

    BAD-DBA-DAB (7/27/2008)

    it looks like he is talking about the growth of the log files (ldf). specifically it needs to be analysed why the log file growth? r u performing any...

    July 27, 2008 at 4:42 am

    #848885

  • RE: Modify report query

    Venkatesan Prabu (7/27/2008)

    The below statement will free up your cache and you can check your performance after executing the below statement.

    DBCC FREEPROCCACHE [ WITH NO_INFOMSGS ]

    Can we execute the statement...

    July 27, 2008 at 1:11 am

    #848869

  • RE: will anyone help me how to design the database

    hari255 (7/22/2008)

    i want to design the database with a requirement of 20gb of data per hour like that the data will grow upto terabytes, so how do i design...

    July 27, 2008 at 1:00 am

    #848867

  • RE: SQL Server 2005 Job email notification alerts

    todd_dawson (7/24/2008)

    Has anyone had any luck getting this to work on a Lotus Notes Server?

    It seems to only want to accept standard email addresses: somebody@somebody.com

    Any suggestions?

    Not sure about lotus...

    July 27, 2008 at 12:45 am

    #848863

  • RE: Logins created in the last X Days

    Mani Singh (6/10/2008)

    Comments posted to this topic are about the item

    Am getting error :

    Msg 208, Level 16, State 1, Line 1

    Invalid object name 'sys.server_principals'.

    July 24, 2008 at 5:56 am

    #847650

  • RE: installing sql server

    GilaMonster (7/22/2008)

    Not sure about SQL 2000. Enterprise edition won't, standard edition won't. Personal edition should.

    SQL 2005, only Developer and Express will install on XP Home and you need to be...

    July 22, 2008 at 6:38 am

    #846358

  • RE: how to get current time & date from sql server using jsp.

    sharma (5/12/2008)

    In sql server getDate() & current_timesatmp gives data & time..

    But i am not access this function through JSP?

    Regards

    use select GetDate()

    July 22, 2008 at 6:08 am

    #846329

  • RE: Modify report query

    stefan (7/22/2008)

    When running a report on my server it has the following text at the top:

    "This report identifies the queries currently residing in the plan cache that have caused the...

    July 22, 2008 at 5:37 am

    #846298

  • RE: SQL Server logins

    Most Welcome:D

    July 22, 2008 at 3:29 am

    #846248

  • RE: to create exe for sql

    abhithakur7 (7/8/2008)

    H! all,

    I m totally NewB in SQL (which can be understood from my question also.......)

    ...

    July 22, 2008 at 3:04 am

    #846234

Viewing 15 posts - 76 through 90 (of 201 total)