Well, not really. It's just something we're not used to see in Windows, but it's a totally normal thing in *nix.

In Win2008 and Win7 folders appear with the link overlay...

Yes, and it worked.

I also tried many other horrible things with junctions, but that would be a whole different story. 😀

You could also read this article by Erland Sommarskog: http://www.sommarskog.se/dyn-search-2005.html

Looks like you want a catch-all query.

See this great blog post by Gail Shaw: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Make sure the SQL Server Browser service is running and that the UDP port 1434 is open on the firewall (both sides: server and client).

Aliases aside, without querying the SQL...

Great! Glad I could help.

george sibbald (3/7/2012)

---

I would ask why? Master and model are hardly updated, msdb not much more so why bother splitting out the log?

You can a make a case for tempdb...

Other than known limitations (no peer-to-peer replication), no AFAIK.

Connect could be a good place to start looking.

You could move those files to a non-system drive and create a junction on the system drive.

That way, the files would appear on both drives, but will physically reside outside...

It doesn't make any difference. The value will be available right after the INSERT takes place and you will discard it anyway if you can't reach the commit for any...

I suspect the problem lies on the CHECK constraint.

If it only has to separate numbers from characters, you could have a much simpler constraint:

DECLARE @A TABLE (

code varchar(10)

)

INSERT INTO @A...

Actually, I was not trying to suggest a solution, I was only pointing out that float is not a precise type and cannot be used in indexed computed columns.

Thanks for...

Watch the virtual event keynote without logging in: http://t.co/DW4m8Ob2.

Looks like it works on Chrome only.

Ironic, isn't it?

I would record database names in a table and then backup only the databases that are not in that table.

Another possible solution: since you don't want database backups for existing...

Great! Glad I could help.