For the difference between EXECUTE AS options, please consult:

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

and as for stored procedure permissions, please consult books online or MSDN. Just creating a proc doesn't mean that users have permissions...

OK, are you sure it's not a client-side issue ?

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

also, see this MSDN piece:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d46c5a0a-643a-4278-adfc-14a212397780/limitation-for-excel-rows-when-exporting-in-bcp?forum=transactsql

You need to confirm that you do indeed have the same permissions on the database. Authentication is a bit weird, but if you both get the same results from this...

..or, if this happens a lot, and it's on SQL2008 and above, you could use Policy Based Management. 🙂

Easier solution would be to use Powershell.

I'm not sure you can use BCP to export directly to XLSX, and I'm not even sure you can use it to export driectly to XLS. You can export to...

Bhuvnesh (9/24/2013)

Can we take help of...

Certainly, partitioning is one case for multiple file groups (although I have seen sliding windows partitions on the PRIMARY filegroup). If you partition-align your indexes as well, that's a win...

From memory, the 20 character limit is usually when you're running a Hybrid (NT4 and Post Win2K) Active Directory. I've not come across anyone using an AD infrastructure (ie Windows...

So, the key bit here is that SQL will *decide* whether the sequence is ascending or descending based on the INCREMENT BY argument. That's a bit misleading if your just...

Agree with those who say the question is a bit confusing.

If you have containment set to NONE, then it's not a contained database, surely ? Especially since all new databases...

You're right, and for the reasons in my blog post 🙂

My bad. Sorry, I'll get my coat.

Even if you hadn't added the constraint to the table, the second program would still fail because there would already be the temp table from the first program.

I wrote a...

Possibly because INSTANCE01 is on the port that would normally be used for a default instance.

Maybe when you make a request to a default instance (i.e. no instance name), a...

You could try using an expression on the connection string for your destination that constructs the file name from variables that are incremented each time you SELECT your TOP 99.