Forum Replies Created

Viewing 15 posts - 661 through 675 (of 694 total)

  • RE: sql server 2005 dba

    Read thru the SQL BOL for anything that you need in regards to SQL. There are even tutorials. That is the best place to look for answers

    Andrew SQLDBA

  • RE: UnHide System tables

    There really are no more system tables in SQL 2005. They are views that look at tables that users cannot see. Look under the Systems Views of the Master database

    Andrew...

  • RE: Copy a SQL Job

    Thanks

    I was hoping that someone knew of a different way.

    Thanks

    Andrew SQLDBA

  • RE: Determine If Database is Online

    Thank You

    This will work perfectly

    Have a good one

    Andrew SQLDBA

  • RE: How to refresh the an instance production server?

    You can also create a Maintenance Task that will do it all for you, then you can schedule it to fire off when ever you need. You could even write...

  • RE: Restore 2005 Database Error

    Thank You

    That was silly of me to ask that. The SQL Books online explained that. I read that yesterday after being asked if I use it, but was not able...

  • RE: Restore 2005 Database Error

    No, should I use that?

    Thanks

    Andrew SQLDBA

  • RE: Restore 2005 Database Error

    Thanks for the advice

    So why is SQL throwing this error? I need to be able to take a backup and restore the database on a different server using the commands,...

  • RE: Drop Login

    What about the Users in a specific database? What table are they stored in?

    I am seeing a user that is in a database that I just restored. I need to...

  • RE: Drop Login

    Thank You

    I could not think of that. Maybe it was too simple or something.

    Feels like a monday after a long weekend. My brain is not working clearly

    Thanks again

    Andrew SQLDBA

  • RE: Database Restore via Maintenance Task

    Thanks for the reply

    I have been looking at some of the scripts that I have found in other posts. However, we do not allow the use of xp_cmdshell to be...

  • RE: SQL Migration and MSDN Access

    I am curious as to why you would need an MSDN subscription to do any of that work. MSDN has nothing to do with a database.

    All you need to do...

  • RE: sql server connection with an asp\vb page

    Because you should always use an ADO connection when using ASP.NET. Or you should use OLEDB connection when using classic ASP.

    ODBC is old, slow, and has plenty of security...

  • RE: Detach and Attach Database with Multiple FileGroups

    Thanks for the info

    It has been so long since I worked with multiple file groups, I wanted a second opinion before starting.

    Thanks

    Have a good one

    Andrew SQLDBA

  • RE: Failed Login

    The account that I am using to start the service is a domain account. I cannot log in as that account. Plus, it is set as a non-human account. This...

Viewing 15 posts - 661 through 675 (of 694 total)