Tag Info

New 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 ...


0

The easiest solution would be to install a new instance of SQL Server (preferably one newer than 2005 RTM, which isn't supported anymore). If you have recent and valid backups: restore your databases on the new instance. If you don't have recent and valid backups: copy over the other MDF/LDF files, attach them, cross your fingers and say 30 hail marys ...


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 ...


0

First: synchronize 1 table from Azure to Sql Server. Second: Execute some Store procedures in the SQL Server 2005 instance. And third: Synchronize various tables from Sql Server to Azure sequentially. You can use the Azure data sync, but its buggy - since I never managed to get it running flawlessly for even a week. It is still in Preview mode with ...


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 ...


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, ...


0

That hexadecimal job name must have come from job_id column which is present in both msdb.dbo.sysjobhistory table and msdb.dbo.sysjobs table. What does below query returns for the hex job ID select sj.name, sj.description, sjh.step_name from dbo.sysjobhistory sjh join dbo.sysjobs sj on sj.job_id=sjh.job_id where sjh.job_id=''--hex value



Top 50 recent answers are included