To me, that looks like column 7 has an invalid value "0000-00-00 00:00:00". Is there blank data for that column in the source?

Since it's a datetime, is...

Check that the TSR_ACCOUNT_VEHICLE table schema is the same between databases.

If it is, drop the article from publisher, drop table on subscriber. Add article, snapshot, should work according to...

SQL 2012 standard edition does not support Always On, you need enterprise edition.

You also need to have a cluster.http://technet.microsoft.com/en-us/library/ff878487.aspx

As I understand it (which may be incorrect), passive nodes do not...

Have a look for open source BI projects like Pentaho, http://en.wikipedia.org/wiki/Pentaho

Open source just means the software is free to use and modify.

That is a very generic question for a 400GB database.

You really need to look at some SQL performance tuning articles, how to analyse wait statistics, perfmon, SQL dmv's...

You need to add a subscription on the subscriber before running the snapshot agent.

eg

EXEC sp_addsubscription

@publication = N'<publication Name>',

@article = N'<Article Name>',

@subscriber = N'<Subscriber Name>',

@destination_db = N'<Destination...

Sounds like bad data to me, eg. Single digit month

declare @OKRGDT numeric(8,0)

set @okrgdt = '2012510' --missing 0 in month

print CONVERT(DATETIME,CONVERT(CHAR(8),@OKRGDT))

Try checking the data and ensuring it is in...

Extended stored procedures only support C# and VB languages (also you should be using SQLCLR instead of XPs). You might be able to do it by calling powershell from...

http://social.technet.microsoft.com/Forums/systemcenter/en-US/9961809f-fd31-472a-b75b-ec2ac908d681/sql-server-2008-r2-pretty-much-gone-after-upgrade-to-81-rtm

sqlfriends (12/6/2013)

Thanks,...

You can set the default backup location in the registry using this command (replace the backup folder)

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory', REG_SZ, N'N:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup'

GO

The "." in ".\\" means "this" folder,...

You should pull the data over the linked servers into a temp table, then join to that. When you join across the link, the local SQL server cannot evaluate...

Check that the SQL service is running, if not, check the SQL error log in Logs folder.

Obligatory

http://xkcd.com/327/

Oh yes, little Bobby Tables we call him

You can rename the database to something other than the original name, then rename again to the original name without the space, eg.

USE [master]

sp_renamedb 'safe_PreTMS ', 'blah'

GO

sp_renamedb 'blah', 'safe_PreTMS'

GO

Obviously check...