Technical Article

RE: SQL 2000 Runtime

  • Reply

Not sure what you mean by "runtime version" or "product version", but Reporting Services can be obtained from Microsoft and is 'free' to use with an existing SQL Server license. See this FAQ for more info:


Technical Article

RE: Writing to a text file using t-sql

  • Reply

In this case, the sp_OAxxx procs are overkill.imo, they are to be avoided if possible. There are way too many issues with sp_OAxxx procs for me to consider them as a reliable option.just my .02 though /Kenneth


Technical Article

RE: Stored Proc vs Query

  • Reply

I removed the parameter from the SP and executed the SP (declare local variable and assign value instead) and it ran fine. I got the results in about 7 minutes. I tested this change in one server and I am testing it in other servers now. I will let you know. Thanks. 


Technical Article

RE: SQL Server Perfomance issue

  • Reply

A table variable only exists during the run of the process that created it as is immediately destoryed at the end and any pages in tempdb associated with it are freed. Basically each time the procedure completes execution the object is immediately destroyed.So unless the stored procedures that create them are looping back on themselves […]


Technical Article

ODBC Connection failure.

  • Topic

Hi, I am not an experienced guy in SQL Server. Please help me to solve my problem. I can connect through Static connection to SQL Server without any problem. Eg, Enterprise Manager or Power Builder etc. But when I connect through Query Analyzer or ODBC I getting the following error. ODBC: Msg 0, Level 16, […]


1 reads


Speaking at SQLSaturday MN 2022


Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022


I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?


Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs


Windows login Token-based server access validation failed with an infrastructure

By Raja mssql

Hi All, One of our windows login is not working which is been configured...

Subtract calculated columns

By pedroccamara

Hello all I am sorry to bother but I really can't find the solution...

Help Parsing String

By Tav29

I can do the Last Name, First Name; my problem is Middle Initial. I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers