Ars Technica

Weird Sql Server Stored Procedure Timeout Problem

We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it.<BR><BR>We've got a stored procedure in Sql Server 2005. It's not terribly complicated but ...
TechRepublic

Understanding roles in SQL Server security

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...
Ars Technica

SQL Server stored procedure assistance needed... (looping?)

I'm not Mr. Stored Procedure so this is (almost certainly) elementary, but I obviously rode the short bus today and need help figuring this out...<BR><BR>I have a stored procedure that updates counts ...
Simon Fraser University

Passing Joins to the DBMS

Although the SQL Procedure Pass-Through Facility has always passed joins to the DBMS, it is now possible to pass joins to the DBMS without using Pass-Through. Beginning in Version 7, the LIBNAME ...
Simon Fraser University

SQL Procedure Pass-Through Facility: SYBASE Specifics

For a complete description of the PROC SQL statements, see SQL Procedure Pass-Through Facility Statements. The following section describes the SYBASE-specific arguments that you use in the CONNECT ...