See the section on Permissions in the BOL article for BULK INSERT:

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

Disclaimer: this is a workaround for a limitation in SSIS

When you output XML to an OLE DB Source component it shows as a byte array which is difficult (maybe impossible,...

Please post the DDL describing the schema in place when you run your script. As I mentioned I am not receiving any errors running your code with a basic version...

I don't know if Service Broker would be of any help here without knowing more about your situation. If after performing a DML operation on Table A you need to...

I created this test table so your script could run in my test DB:

CREATE TABLE dbo.MYTABLE (id INT) ;

After that your script executed without error in SSMS. I am using...

Do you mind posting your code? I am very curious to see how you solved this. I suspect that Jeff may want to have a look as well.

What kind of function? Table-valued (multi-statement or inline) or Scalar?

barakos,

I am guessing you have an Oracle background and are looking for something similar to the %ROW_TYPE functionality but it does not exist in SQL Server.

There is an open...

This is a common request. In my opinion "in-process EXPORT" functionality is a feature that would be very useful.

See this similar post:

http://www.sqlservercentral.com/Forums/Topic1061652-392-1.aspx

Here are some workarounds in preference order:

1. SSIS /...

Looks like homework...

Have a look at the DATE/TIME functions in Books Online.

Generically what you want to do is tie the check-in event in TFS Source Control to execute a build routine within Team Build. The build routine can do pretty much...

Vote for this connect item if you agree that we should have an in-process EXPORT command:

https://connect.microsoft.com/SQLServer/feedback/details/224026

I think Prasad might be looking for a different way to write a file to disk from a T-SQL programming context without using bcp via xp_cmdshell. This is a commonly...

I have heard of it but have not tried ApexSQL (and their website won't allow me to register for a trial period with my gmail account...lame). Do you know if...

I spent a few minutes looking around and experimenting and I did not see a way to do it. I don't know everything you're trying to do, however while it...