🙂

Interview?

SQL Server doesn't have a DECODE function, but you can code your own:

CREATE FUNCTION dbo.DECODE(

@expression AS sql_variant,

...

I think that your best option is installing Enterprise or Standard edition on the server and then set up merge replication with clients.

Client machines will run Express edition (10...

+1

+1

This is how I would do it (and have done in the past):

1) On the...

Great! Thanks for the feedback.

However, please make sure that the REVOKE command did not REVOKE the DENY specification.

I know it could sound confusing and I'll try to expand it a...

I believe so. Try it yourself and, possibly, let us know.

HowardW (2/16/2012)

---

Gianluca Sartori (2/16/2012)

---

Use PortQry to test the sqlbrowser service from the client machine.

If you can't connect to it, you can't connect to named instances (you wouldn't know which port...

Use PortQry to test the sqlbrowser service from the client machine.

If you can't connect to it, you can't connect to named instances (you wouldn't know which port to connect to).

DENY overrides GRANT.

Try REVOKE instead.

Why don't you use one of the many SQL Server Agent replacements?

- SQL ClockWork[/url]

- SQL Scheduler

- ExpressMaint[/url]

- Standalone SQL Agent[/url]

- Job Scheduler[/url] (Commercial)

On another note, can I ask you why you can't install SQL Server 2005 on your computer?

There's no way to do that with physical backups (I mean BACKUP / RESTORE commands).

You could script out the whole database DDL and then export and import data using SSIS...

Then, apparently, you don't have memory issues. How did you check memory pressure? Which counters did you account for?

Could...