I think you might have a 2012 alias set up on your client.

https://msdn.microsoft.com/en-us/library/ms190445.aspx

Just saw this, and didn't want to leave it unanswered.

If you are on 2005, and can't use PoSh, I'd actually script this with SQLCMD and use VBScript to call SQLCMD...

Sunscreen is important. I'd also caution you to bring a light jacket always. A 90F day can turn cold quickly when the sun goes down. Much different than sea level,...

If the users have access to the tables, you can't prevent this. You could make it hard, perhaps with some trigger that looks for Access directly manipulating things by using...

It's complicated in T-SQL, but not overly so. However, I agree with Sean and Ed. If you think this is overcomplicated, I think you need to work on better understanding...

Good to see some of you doing code reviews. Not a lot of response, so I suspect many aren't.

Those of you doing testing as well, we'd love to hear more,...

You have a WHERE clause that limits to 2014. You'll want to group by years to get the values by years.

However, if you want to move them into columns, you'll...

Are table1.username and table2.username columns? I'm assuming you mean that you want to check if any of the values in table1.username exist in table2.username. That's an easy check:

if exists (select...

Either of these applicable?

https://support.microsoft.com/en-us/kb/182867

http://stackoverflow.com/questions/15367066/access-database-engine-stopped-the-process-because-you-and-another-user-are-atte

Have you tried a repair? https://support.office.com/en-in/article/Compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2

You must have some alias on the first machine.

UDP 1434 is the listener for the browser service. It lets you know things are working. The connection (by default) is on...

jonathan.crawford (4/24/2015)

---

Steve, my brother is getting hitched on the 4th of July weekend in Breckinridge. I'm not sure we're going to be able to make it, but assuming we do...

The resource file has been updated with a new version from Adam.

john.arnott (4/22/2015)

---

Steve,

Two food items to not miss: The Gordon Biersch mini-brewery's garlic fries (perfect excuse for a beer to wash them down), and the Cha-Cha Bowl from Orlando...

Heading to Pac Bell tonight to see Dodger v Giants. Kershaw v Baumgartner.

Excited. First time at the park.

sp_executesql isn't in your linked server db. It's in master.

The issue is that you really need to execute this as master.dbo.sp_executesql, but through a linked server.

You'd be better off using...