It sounds as though you may have restored these databases from another server to here. If this is the case, and these are SQL logins (not NT logins), use...

I'd start with the internal security on the linked server object, see who it's imitating, and see if that login can get to the view/has access to the other server.

Definately looking forward to parts 3 and 4, thanks for the articles!

For the item you posted, no, but since we're discussing 2k5 and that...

Do you have the SQL Server error that gets kicked up when you try to call the local view that looks to the linked server view from .Net?

An additional method...

To answer the specific question: You *can* alter the database restoration method via an Alter Database command before you begin, and thus the logging will only store the transactions that...

LutzM (9/8/2010)

---

Craig, you're absolutely correct regarding both statements! My fault. I'm sorry. :blush:

I usually try to avoid using DATEPART() at all due to the side effects of DATEPART(dw,) and ...

elayevskiy (9/7/2010)

---

When I run this query on the console window I notice that results start showing up in the results window instantly and then sql server continues to pull data...

Example below:

declare @blah DATETIME

SET@blah = '2010-09-08 13:45:00.000'

print LEFT( datename(dw, @blah), 3) + ', '

+ left( datename( month, @blah), 3) + ' '

+ datename( dd, @blah) + ',...

Lutz, since when does a case statement in a returned column...

I don't have a way to turn those off, but all of your dynamic code should be used with sp_executesql using parameters to help protect against sql injection if you...

In Books Online (Help-Index), look up the CONVERT() function. It will give your your date time formatting options there.

Code snippet: Alter as needed

CASE WHEN DATEPART( hour, @myDate) between 7 and 13 /*(1:59PM and lower)*/ then 1 when DATEPART( hour, @myDate) between 14 and 23 then 2 else 3...

Please note the sample build code in the original post, where it shows that the first set of columns (for more then 8 fields) are in the most significant byte....