If SQL 2005 or above you should look at using EXECUTE AS. You can create a stored proc that can create logins as needed as if a sysadmin was doing...

What does your requirement say if the day passed is between the third Saturday of the month and the last day of the month?

Ooops, misread your comment "current day passed...

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...