Hello,

Did you see this TechNet article:-

http://technet.microsoft.com/en-us/library/ms190181(SQL.90).aspx

Regards,

John Marsh

Hello,

Are you getting any related errors in the Windows Event Logs, or displayed in the Replication Monitor?

If it is related to (Merge) Conflict Resolution then this BOL Topic shows you...

Hello,

A couple of T-SQL statements to try from a query window connected to the DB in question:-

Select * From INFORMATION_SCHEMA.TABLES

Do you get a list of the Tables that you were...

Hello,

Did you lookat using DB Detach/Attach instead of Backup/Restore? It would be more efficient if it worked.

Regards,

John Marsh

Hello,

Do you have SSIS Logging configured for the Job Step? Any useful diagnostics captured there that you could post?

Alternatively, just for bug hunting you could convert the Job Step to...

Hello,

May be take a look at this article:-

http://en.csharp-online.net/Building_Reports_in_SQL_Server_2005%E2%80%94Setting_Report_Parameters_with_Stored_Procedures

Regards,

John Marsh

Hello,

It is a good idea to (always) use Scripts to deploy to your Prod environment, that way you can also apply them to your DR Site, and keep things in...

Hello,

Being European I’ve never modelled baseball before, so it was vaguely interesting to give it a go.

Entities can be discovered from the major nouns in the problem description, but you...

Hello,

May be take a look at Mark Han’s posts to this thread:-

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic66541.aspx

It looks like "SQL Server Remote Setup" is an orphaned job from a SQL Installation and (assuming no installation...

Hello,

You are missing a couple of commas at the ends of your Column definitions in the Create table dbo.TestHistory statement.

If you are using SSMS you can double-click the Error Message...

Hello,

Are you a member of the sysadmin role on the SQL Server? I suspect you can not see or amend the Step Properties because you do not have a high...

Hello again,

Apologies for the delayed response, but I have had a few days holiday.

When you run the failing job with verbose Logging turned on, what is the full error text...

Hello again,

I suspect what you are after is the Row_Number function.

Possibly something like:-

Select

customerid ,

Row_Number() Over(Partition By customerid Order By customerid Asc) As serialno,

Product

From

YourTable

Regards,

John Marsh

Hello,

I would suggest you need to explain your problem more.

Just in case I have correctly guessed what you need: Truncate Table resets an Identity column to its seed value.

Regards,

John Marsh

Hello,

How big do you expect the Backup File to be, and how much free space do you have on the Target Drive? Is the Target Drive formatted for NTFS or...