SQL Server Knowledge Sharing Network (SqlServer-qa.net)

Browse by Tags

• bigint
• design
• dynamic sql
• int
• numeric
• object
• schema
• security
• sql server
• tsql

• How to deal: "The EXECUTE permission was denied on the object 'sp_executesql', database 'mssqlsystemresource', schema 'sys'." issue

  One of the TRUSTWORTHY features within SQL Server 2005 will be like when you are running a stored procedure with a dynamic execution query ( sp_executesql or EXECUTE), you may receive the following error message: Server Msg 229, Level 14, State 5, Line... Posted Aug 11 2008, 12:13 PM by satya with | with 1 comment(s) Filed under: security, sql server, dynamic sql, tsql, database, object

• Database design - choosing required data type for numeric values

  Here is the forum post I found interesting and suggestions to keepup when you have a data (numeric) in place in large scale, here is the Running-out-of-integer-space forum post. Posted Mar 10 2008, 12:28 PM by satya with | with no comments Filed under: sql server, schema, database, int, bigint, design, numeric