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

SQL Server 2000: Recursive Stored Procedure for Parent-Child relationship

Hey All,<BR><BR>Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table ...
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 ...
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 ...
Simon Fraser University

CONNECT Statement

Using the CONNECT statement is optional for some DBMSs. However, if it is not specified, the default values for all of the database connection arguments are used. Any return code or message that is ...