A userA has excecute permission on a stored proc procA that runs on server1. In the procA there is a use of the linked server that talks to the server2...

Create SSIS package.

OR

INSERT ... SELECT * FROM OPENROWSET(BULK...) statement

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

1.) (Wide solution) Structure a table with 1024+2 columns.

It’s possible with Wide Tables.

A wide table is a table...

Yes, please :-D. The good point here is "the DDL is missing". So you may take...

Jeff Moden (11/18/2011)

---

I'm not going to give you the answer but I will tell you where to look for...

Where are you not able to login to, SQL Server / Application? If SQL Server what’s the error you are getting?

For...

waxingsatirical (11/18/2011)

---

Hi All,

I think filtered indexes must be my favourite feature of SQL server, am trying to a use a covering filtered index to speed up my querying when I...

When you load 2nd page use different Connection String.

@declare @myString varchar(max)

@myString = 'SELECT ...'

exec @myString

The above piece of code is Dynamic Query (not very efficient). With this, you are also at a risk of SQL injection.

SQL Server tries to optimize the execution of your stored procedures by creating compiled execution plans. An execution plan for a stored procedure is created the first time a...

Better:

Configuring 1 Failover Cluster Vs Managing 30 Mirror...

I am not sure if it's applicable. Please verify at your end.

BUG: Error message when you try to install SQL Server 2005 Service Pack 1: "Unable to install Windows Installer...

Actually "It depends"

Also, some tables are likely to have high volumes of inserts/updates which could be possible candidates for a lower...

OR

EXEC sp_help 'MyTable' -- It will return more than what you want.

gcresse (11/17/2011)

---

I'm adding the SPARSE columns with this line of code:

'ALTER TABLE #tmpVintage ADD [VntRun' + CAST(triInputLotKey AS VARCHAR) + '] DECIMAL(18,5) SPARSE NULL, [VntPct' + CAST(triInputLotKey AS VARCHAR)...