Have you searched SQLServerCentral for a String Splitter[/url]?

I don't know why you've ended up in this situation, but I've experienced some cases where Visual Studio (BIDS or otherwise) is generating or altering XML so that it later...

Use reverse first to get the reverse string, search for the position of >-, use sub string on the reverse string, then reverse it again for your result

The "default" permission would to be that the user installing SQL server Is admin, no other have access. In that case, the old laptop user woul need to grant access,...

There are a LOT of factors affecting performance. Does the packages use local databases only, or are there network traffic involved for only on of the servers? How fast is...

In my opinion, this is not a good solution at all. Unless I had extremely many customers, I would have a separate database for each customer, mainly to maintain security.

I...

Indeed, ../ is one level towards the root, or up in the root structure to its parent element. If you start the path with / it starts at the root...

nodes return a virtual node, or if you want, a default path in the XML tree structure. This is most likely NOT the root of the document, and as such...

Ah, welcome to the sweet beauty of xml. Sorry I don't have time to write the code for you. You're actually doing things right so far. When you get the...

XML.nodes() in combination with XML.value() should do the trick.

sys.syslogins is a view based on three tables, sys.sysxlogins, sys.sysprivs and sys.sysmultiobjrefs. I believe the password is stored in the latter, but I'm not 100% sure. You cannot query any...

Please take the following statement with a grain of salt, but I've heard that Microsoft decided not proceed with certification on SQL Server 2008 R2. If you have a look...

Just go ahead. It is fully supported to have additional databases in the same instance, and actually a very common scenario. I rarely see any instances with just SharePoint databases.

This should give you what you want. Note the link at the very top of this page regarding emtptying files.

How to: Delete Data or Log Files from a Database (SQL...

Two repeating should definitely be investigated if you are interested in less secure pin codes, as it makes it much easier to see the pin code typed. My point here...