i think joining sys.partitions gives me which partitions the tables or the indexes reside;

most of the other objects (procs, views, functions triggers are just compiled code, and their definitions...

one way is to look at sys.columns, which has an is_identity indicator:

select

object_name(object_id) as TableName,

name As ColumnName,

is_identity

from sys.columns

I would test the linked server as that user to see if the problem is in the credentials:

EXECUTE AS USER='mydomain\lowell'

--who am i?

select user_name()

,suser_name()

--do stuff

SELECT TOP 1 * FROM myLinkedServer.DatabaseName.dbo.TableName

--change back...

just checking the basics here:

MyLogin is actually a user in the database, right? you know it cannot be a login, but must be a user, right?

--the EXECUTE AS must be...

sp_find

this home made procedure is probably my most used proc on my dev server!

too many times i think to myself "i know there are columns or tables that have...

Are you talking about sending an SMS to a phone (Shor tMessage Service)

or talking bout sending an email in general, where a smart phone picks up mail like a normail...

Joe-420121 (7/10/2012)

---

lowell,

I get err msg respectively:

-----------------------------------------------

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

Msg 7303, Level...

try openrowset like this, using the aCe driver;

this is a tested working example for me:

SELECT * FROM OPENROWSET('MSDASQL',

...

sjerromeharris (7/10/2012)

---

Thanks - v helpful.

If I want to select just the top 10 clients in terms of costs billed/branch (top ten clients in branch 1, top ten in branch 2,...

Welsh Corgi (7/10/2012)

---

I understand that you need both a...

without an explicit ORDER BY department,SumOfCostsNet at the end of your query, SQL server is free to return the data in any order at all.

the order you get is the...

crazy4sql (7/10/2012)

---

there is a report that you can run that till tell you who last changed the stored procedure and when. from ssms navigate to your database, right mouse click...

crazy4sql (7/10/2012)

---

its because, sql not able to understand

alter database @databasename set recovery simple

in your code.

If you put this in some variable, like I did in @sql and then...

i should also mention my reports are mostly agaisnt hte OLAP , with minimal data warehousing; I agree witht eh other posts, it makes sense in a data warehouse scenario...

Well Andy this is all one man's opinion, although it is built from experience:

my basic premise: a static table that has rolled up totals is never as accurate as the...