Tag Info

Hot answers tagged

3

Don't know that you're going to get anything much simpler than this: DECLARE @x TABLE(a VARBINARY(64)); INSERT @x(a) SELECT 0x480069002100 UNION ALL SELECT CONVERT(VARBINARY(64),(REPLICATE(N'x',32))); SELECT CONVERT(NVARCHAR(32), a) FROM @x FOR XML PATH('tag'); Results: <tag>Hi!</tag> ...


2

When you right click on Tasks and use the Import Data/Export Data task, you're building an SSIS package in the background. In the penultimate screen, you're usually greeted with Instead of Run immediately, check "Save SSIS Package". I generally save to the File System with the Package Protection Level of Do not save sensitive data. Your preference may be ...


2

Error message says mssqlsystemresource is not found.,you can try copying resource database mdf and ldf to its place from another sql server instance. Source version from which you will copy resource database mdf and ldf should be same as destination version Below link may help you in knowing how to check resource database version and location of resource ...


2

As per Microsoft Official document SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. You will receive a warning in the Action Center if Windows 8.1 or Windows 8 detects an instance of SQL Server 2005. To resolve this issue, ...


1

Eduardo Molteni asked this in 2012 for running on Windows 8 (not 8.1) and came back a few days later with his solution. You might give it a try. http://stackoverflow.com/questions/13520551/how-to-install-sql-server-2005-express-in-windows-8 The secret sauce, according to Eduardo is: After you run the install file SQLExpr.exe look for a hidden folder ...


1

Would it be a potential bottle neck on performance if a statistic had already been created automatically for the same column(s) by SQL Sever and my script creates a duplicate statistic? Surely you can write your script such that it detects such a duplicate statistic, instead of just blindly creating another one (possibly multiple times)? We do this for ...



Only top voted, non community-wiki answers of a minimum length are eligible