we resolved this is issue with the help of the OS people, there was an issue with the VM and the drive. once the server got rebooted the issue got...

I was trying to restore the master database but couldn't able to connect to sql server using sqlcmd and even when i use the single user mode flag. in this...

MY E Drive is working fine and i am able to access it and the files in the drive . i do have some user database on the server

Should have been back to BIDS instead of SSDTBI. we call simply BI Tool

Good article, looking for more in this series.

What is there inthe dataflow? How are you handling error rows, are you writing them some where?Even there might be truncation of the data when converting from sql server to...

Good Question , even if we have the primary key and want to drop it, we need to disable the change tracking before we drop the constraint.

are you looking for something like this

exec ('select @liststr = coalesce(@liststr+'+''''+','+''''+' ,'+''''+''''+') + quotename(column_name)

from '+ @server + '.'+ @db+ '.information_schema.columns where table_name = '+ ''''+ @table+'''')

without taking server offline it is not possible to move the system db's to another location.

you are @wrong forum, this is more of SQL thing

There is a nice article on CDC from Pinal

https://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/">

https://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/

i would recomend using of history table and some after triggers to use it in your db to track the...

Perfect Explanation by Hugo

http://support.microsoft.com/kb/295305

what could be the better approach in this kind of situation , is there any better option than this

DECLARE @MoreColumns bit;

SET @MoreColumns = 1

Create table #table( id int )

IF @MoreColumns...

I am not sure if this could be sort of any help for you

http://msdn.microsoft.com/en-us/library/ms188396.aspx