In SQL Server 2005 and 2008 it’s possible to start an agent job with T-SQL syntax. This is frequently useful. For example, you may have a job that you’d like to have an outside application invoke. Jobs can also be used to execute SSIS packages. Using T-SQL to execute a job that runs an SSIS…
Kategori: Microsoft SQL Server
Microsoft SQL Server
Less Than Dot – Blog – The Ten Most Asked SQL Server Questions And Their Answers
by Bo Jensen •
Less Than Dot – Blog – The Ten Most Asked SQL Server Questions And Their Answers
Microsoft SQL Server
SQL Script: Search all tables for a specific field
by Bo Jensen •
DECLARE @NAME_TO_SEARCH_FOR nvarchar(50) SET @NAME_TO_SEARCH_FOR = ‘%photo%’ SELECT sysobjects.name AS Table_Name, syscolumns.name AS Column_Name FROM syscolumns INNER JOIN sysobjects ON syscolumns.id = sysobjects.id WHERE syscolumns.name LIKE @NAME_TO_SEARCH_FOR AND sysobjects.Type Like ‘U%’ SQL Script: Search all tables for a specific field
Microsoft Dynamics Ax, Microsoft SQL Server
Tuning the startup and managing memory on AX-SRV-01 – Reflections on Microsoft Dynamics AX – Site Home – MSDN Blogs
by Bo Jensen •
Tuning the startup and managing memory on AX-SRV-01 – Reflections on Microsoft Dynamics AX – Site Home – MSDN Blogs
Microsoft SQL Server
How to process a cube in a SQL Agent job – DavidWimbush
by Bo Jensen •
How to process a cube in a SQL Agent job – DavidWimbush
Microsoft SQL Server
SQL Server 2000 Survival Guide
by Bo Jensen •
Selvom det efterhånden er en gammel artikel, så er den meget god fordi den dækker en masse basale principper og teknologier i SQL Server. SQL Server 2000 Survival Guide
SQL Reporting Services
Building Report-enabled Applications with the New ReportViewer Controls (Part 1 of 2)
by Bo Jensen •
Building Report-enabled Applications with the New ReportViewer Controls (Part 1 of 2)
Microsoft SQL Server
Download details: Microsoft SQL Server 2008 Feature Pack, October 2008
by Bo Jensen •
Download details: Microsoft SQL Server 2008 Feature Pack, October 2008
Microsoft SQL Server, SQL Reporting Services
Working with the Report Builder in Microsoft SQL Server 2008: Part 1
by Bo Jensen •
Working with the Report Builder in Microsoft SQL Server 2008: Part 1
DotNET, SQL Reporting Services
Create a web service directly from Sql Server 2005 using an HTTP Endpoint – Raymond Lewallen – CodeBetter.Com – Stuff you need to Code Better!
by Bo Jensen •
Create a web service directly from Sql Server 2005 using an HTTP Endpoint – Raymond Lewallen – CodeBetter.Com – Stuff you need to Code Better!