That first message suggests a Kerberos issue. Try working through this[/url].

John

I think unless you change the design of your database, this is always going to be a bit flaky. However, this will work for the data you posted:

WITH Inners...

There are pros and cons. Your query will return (possibly) unexpected results if there are gaps in the data or two dates in the same week. But yes,...

Actually, DENSE_RANK would probably be a better choice than ROW_NUMBER. That way, if for any reason you have two dates that are in the same week, they won't appear...

SELECT

Time_Started

,ROW_NUMBER() OVER (ORDER BY DATEPART(wk,Time_Started)) AS Week_No

FROM #tbl_data

John

Prakash

What question are you asking here - how to do running totals, or how to change how they're partitioned at run time?

The answer to the first question is to use...

Ah yes. My mistake. I've edited the offending post.

John

No, but you can query sys.partitions to get the rows per table in a database, and use something like sp_MSForEachDB to loop through all databases and execute the same query.

John

Rushi

What security model are you using on your data source? It sounds if you're connecting as your own Windows login. If that's the case, the most likely explanation...

You can't disable a Windows login, but you can revoke the CONNECT permission.

John

What do you get if you run this?SELECT

o.name AS TableorViewName

,c.name AS ColumnName

,t.name AS TypeName

,c.max_length

FROM sys.indexes i

JOIN sys.objects o ON i.object_id = o.object_id

JOIN sys.index_columns ic ON i.object_id = ic.object_id AND...

Does this help? I found it by typing the title of your post into a search engine.

John

Yes. Join to sys.index_columns, sys.indexes and sys.types.

John

What do you get if you run this?

EXEC xp_fixeddrives

John

Join sys.indexes to sys.objects. You'll need to do that in every database (or use sp_MSForEachDB), though, if you don't know what database the index is in.

John