Ryan Garaygay on Code, Creativity, and Community

Category: Data

  • Generate SQL Job Schedule Description

    I was actually calling the system stored procedure "msdb.dbo.sp_help_jobschedule" in my previous post about modifying column list from a called stored procedure, While working on that I noticed that [more]the description (schedule_description) being returned by stored procedure (if you set @include_description = 1) returns date and times as integer values (rather than date/time format). While…

  • Modify column list from a called stored procedure

    I needed to trim down the number of columns returned from a system procedure (eg. for performance) and unfortunately [more] it's not possible to simply call: SELECT * FROM EXEC <stored proc to call>  Eventually, I had to resort to an INSERT-EXEC approach (insert the result set resulting from an EXEC <sp> call to a…

  • Visual Studio 2008, SQL Server 2008, Windows Server 2008 Launch Philippines

    Microsoft Philippines Launch for these new 2008 products will be on April 10, 2008 at the SMX Convention Center, SM Mall of Asia Complex. Public Registration will begin on March 24 on this Registration Link  Stay tuned for updates on: http://msforums.ph/forums/p/46593/220607.aspx#220607 Microsoft Philippines Heroes Happen Hope to see you there!

  • Introduction to SQL Server 2008 Free eBook

    I belive all you need is a Windows Live ID. The book is not complete yet. Only chapter 1 (Declarative Management Framework) is currently viewable without signing up and signing up includes Chapter 11 (Transact-SQL Enhancement). But when the book is completed the whole content of the book will be available for free. The 1st…

  • Problem with SQL Database Mail: ExternalMailQueue missing

    UPDATE: Just wanted to point out that it's likely that this issue was after installing .NET Framework 2.0 Service Pack 1 (SP1) I just updated an entry in the technet forums regarding a previous issue I've encountered before. I was able to solve my issue by reinstalling SQL Server (which is not a very brilliant…

  • Reading SQL error messages and sp_executeSQL

    "Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'." A few days ago, I ran into the error mentioned above. sp_executeSQL requires that the first two parameters (statement and parameter declaration) be of type ntext, nchar or nvarchar http://dotnetjunkies.com/WebLog/richard.dudley/archive/2004/09/29/27169.aspx When I ran into this error, I copied the error message and googled (so much for the "googler…

  • SSL and SQL Server 2005

    Getting an "error occured during the pre-login handshake". in SQL Server? I just spent the last few hours trying to figure out why I can't connect to my local SQL 2005 instance and getting the error above. I was using SQL Management Studio. I tried tweaking Network/Client Configuration, Protocols using SQL ConfigurationManager, Surface Area Configuration…