SELECT SU.Name + '.' + SO.Name

FROM SysObjects SO

    INNER JOIN SysUsers SU

    ON SO.uid = SU.uid

Use a WHERE clause to limit type of object on xtype. 

Well, what's the error?

This has been posted twice and answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=291273

You will still be able to restore from a complete backup, but if you are planning on rolling forward by applying tlog backups, you must have all of the tlog...

I think this is an Excel issue and not a BCP issue.  Once you open the Excel file, right-click on the datetime column and select format cells.  There select the...

1. If you restore the master, it should keep the collation that it had previously. 

2. In order to change the instance collation, you must rebuild the master database (as...

SELECT O.mbrnbr,

    O.accttype,

    O.name,

    N.mbrnbr AS Expr1,

    N.accttype AS Expr2

FROM Oct O

    LEFT JOIN Nov N

    ON O.MbrNbr = N.MbrNbr and O.AcctType = N.AcctType

WHERE N.MbrNbr IS...

You can use the NOLOCK hint in your select to prevent it from being blocked by another transaction that is locking the row; however, this means that you may have...

Convenience is for users and testers.  Developers who do not know how the data is structured write poor code.  By definition, a convenience is something that saves time and effort. ...

I guess I'm still not quite clear on the need to query the text file (especially using cursors).  So you generate a text file on client machines using BCP, then...

You may be correct, but I would still recommend watching your system log for other hardware related messages as your original message references a bad page file (which is in...

The only way that I am aware of is if you would read that file back into a table and query that table, but that just puts you back at...

"No, you do *not* need to run CHECKIDENT after deletions in your table."

Correct, you do not have to run CHECKIDENT (or any other method of removing gaps and islands from...

Does your new server have the same CPU, RAM, and disk subsystem as the offending server?  You may want to monitor these three areas and duplicate the problem on your...

The vast majority of the time, a timeout expired message means that an operation is taking longer than the timeout threashhold.  This is usually due to resource contention of some...