SQL Server does not provide a tool to view the contents of the transaction log (that I am aware of).  There are third party tools that will do this for...

While SQL Server doesn't appear to have any obvious problems when running on Windows 2003, you should test your application on a Windows 2003 server prior to moving your production...

Also check out the temporary tables and table data type entries in BOL.  This may be a good to use the table data type. 

Can you post your file and the schema info. for your table?

Sorry if this is appearing twice.....

Is this a production job that is all of the sudden having problems, or are you working on developing the BCP job from scratch??  There...

Judging from the size of the backup file, 26MB, this is a relatively small DB.  Knowing that you must restore the DB, it is obvious that you are aware that...

So this is before you even get to select the restore options?? Ouch....Is this a production DB?  Even so, if you must do a restore, you may have to detach...

'enterprise manager just stops responding'

What do you mean by stops responding??  Many times EM appears to be hung whild performing restores due to the backup file / DB size as...

Just as Alzdba said, there must be a reason why the trigger was placed on the table.  You need to know what the trigger does before you go about disabling...

I searched through the Quest Central knowledge base and found that the Spotlight installation includes a script designed to remove all Spotlight objects from a DB (Spotlight creates may stored procedures...

I thought there may be a method using Spotlight to perform the work.  The target DB already has the same tables in it, so I will have to merge the...

This question's wording was obviously quite misleading judging by the debate. I also followed the line of thought that LAST_ORDER_DT was a column that would be frequently updated making...

I have a different configuration for my log shipping. Here are the elements to my setup:

1) Production DB - your maintenance plan can do anything you want except TranLog...

You can view MDF/LDF file sizes through Windows Explorer, or by right clicking on the database in EM and selecting Properties. The data file and transaction log tabs will...

I read the kbase article. I am not using the Copy SQL Server Objects, but my DTS job is using BCP, which according to the article is the component...