I have used CTE to overcome the issue

Jeff, It would be great if you can guide us..

Its In OLTP

1. The first thing to ask is, what kind of table is it? Is it an OLTP table or an audit table where rows are written but never updated?

2. What...

To give a little background on my case.. the below error can be seen only when I run the trace from profiler for the event " Exception " :

the...

how am i going to capture the event of the user in the backend ... if its not an database login ??? any sysprocesses is mapped to that sqlogin .....

Ok.. got it... so how would i insert the data in to file table .. with out moving the files to share ? sorry.. If this is a stupid...

i am copying the files to file stream share .. to populate the file table... so I my question would be .. what is the windows share path for...

I am trying to copy the some files to fileshare of file stream using cmooand line .. i am encountering the same issue.. can you please let us know... how...

can you please explain how is this change handled in sql server ?

Hey Steve,

I am a step ahead of our friend.We have data moved from one data file to another.This is nearly 900gb in size.We have transactional replication setup with push...

thanks boss!! just checking for the available options

Thanks for the reply.. Will give a shot and update the post...or will comeback if could not add the article.... 🙂

not yet ... after i saw the message above i monitored the replication for 1 hour.. saw no progress in the replication monitor screen....so dropped the article I have...

thanks

🙂