SQLServerCentral / Discuss Content Posted by Robert Marda / Article Discussions / Article Discussions by Author

Documenting Stored Procedures

Robert W Marda — Sun, 12 Oct 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/documentingstoredprocedures.asp

Handling The Text Data Type

Robert W Marda — Fri, 02 May 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/handlingthetextdatatype.asp

Creating a System Stored Procedure

Robert W Marda — Tue, 18 May 2004 19:46:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rm

Multi-Server Administration

Robert W Marda — Wed, 01 May 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/multiserveradministration.asp

Understanding Execution Plans Part 1

Robert W Marda — Tue, 16 Jul 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/understandingexecutionplans.asp

Dynamic SQL vs. Static SQL Part 2, Code

Robert W Marda — Sun, 03 Mar 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/dynamicvsstatic2.asp

Create And Execute Table Script (SQL Server 2000)

Robert W Marda — Sun, 11 Nov 2007 02:25:22 GMT

Comments posted to this topic are about the item [B]Create And Execute Table Script (SQL Server 2000)[/B]

Output Parameters

Robert W Marda — Fri, 21 Nov 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/outputparameters.asp

Using Check Constraints

Robert W Marda — Wed, 02 Oct 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/usingcheckconstraints.asp

Concat String of More than 30000 Chars

pankajm — Sat, 27 Sep 2008 01:34:34 GMT

Hi allI am facing an issue in SQL 2005 in which I want to print a string of more than 30000 chars and they should be appended to each other.The requirement is that, I want to create a script dynamically for the sp which is having 30000 chars.I got the result in separate chunks but not able to put them together as the maximum supported datatype is varchar(8000). Not able to use ntext and text as they cannot be used as local variables.It would be great if anyone can help me in the same.Thanks

Nesting Stored Procedures

Robert W Marda — Fri, 16 May 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/nestingstoredprocedures.asp

Performance Adding Hints

Robert W Marda — Wed, 04 Sep 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/performanceaddinghints.asp

How Dynamic SQL Can Be Static SQL Part 2

Robert W Marda — Sat, 11 May 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/howdynamicsqlcanbestatic2.asp

How to Build Dynamic Stored Procedures

Robert W Marda — Fri, 18 Apr 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/howtobuilddynamicstoredprocedures.asp

Mark DTS Task As Complete

Robert W Marda — Mon, 12 Nov 2007 08:12:12 GMT

Comments posted to this topic are about the item [B]Mark DTS Task As Complete[/B]

Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)

clyde.b — Mon, 15 Oct 2007 15:13:56 GMT

im new to sql. i have created a delete trigger in table1. once i deleted the record in table1 it will also delete that specific record in Table2. And in table2 also, i had created a delete trigger. Once the record of table2 will deleted, that specific record will be deleted in table1. But everytime i delete i delete a record there is an error message will appear. And its "Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)". What does it mean? Can you help me with this? Any one. How can i create a delete trigger in two tables without having an error like this?

Eliminate Weekends And Holidays From Days Elapsed

Robert W Marda — Thu, 04 Oct 2007 14:19:50 GMT

Comments posted to this topic are about the item [B]Eliminate Weekends And Holidays From Days Elapsed[/B]

Block the DBA?

Robert W Marda — Sat, 25 Jan 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/letsblockthedba.asp

What Your SP Can Return

Robert W Marda — Sun, 13 Jul 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/whatyourspcanreturn.asp

Manipulating And Using DateTime Data

Robert W Marda — Fri, 08 Oct 2004 15:31:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/

RE:

amit walia — Thu, 14 Apr 2005 17:57:00 GMT

ur article is very usefull to me but what bout the performence like SP ment to run next time form the memory and if dynamic query keep on changing every tme how it will make cache and performence is faster evry time.thanks

Does Your SP Choke on Errors

Robert W Marda — Sat, 21 Jun 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/doesyourspchockonerrors.asp

Review of SQL Compare v3

Robert W Marda — Sun, 28 Dec 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/reviewofsqlcomparev3.asp

Uses For Derived Tables

Robert W Marda — Fri, 01 Feb 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/derivedtablebasics.asp

Auditing Through Triggers

Robert W Marda — Fri, 11 Jan 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/auditingtriggers.asp

Review of SQL Compare v3

Robert W Marda — Sun, 28 Dec 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/reviewofsqlcomparev3.asp

Stored Procedure Development Cycle

Robert W Marda — Fri, 29 Aug 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/storedproceduredevelopmentcycle.asp

SQL Injection Attacks

David.Poole — Thu, 22 May 2003 09:39:00 GMT

quote:
I'm sure you know this articles from http://www.appsecinc.com named Manipulating Microsoft SQL Server Using SQL Injection. Or Advanced SQL Injections in SQL Server Applications by http://www.ngssoftware.com.

I understand the principle of the above article, I just don't understand how someone could submit the commands to the server unless they already had access to the server. Can anyone throw some light on this?

Output to text file

mcdonatl — Tue, 27 May 2003 06:36:00 GMT

What T-SQL commands are available for writing and reading to/from a text file? I need a low tech interface to another system. Any advise as to what to do/not to do, use/not to use?

sqldmo

padmakumar_pga — Sun, 02 Feb 2003 02:44:00 GMT

Friends1) I used PWDencrypt and pwdcompare function in sql7.0 .but same is not working with sql2000 . compare always return false why ?2) I written a tool for warm server (standby ) . for this I used sqldmo backup and Restore objects . I did like this every day tool will take a full backup and after that differential backup at a given interval . and restore standby database in with standby mode(|Readonly) .it need a file called undo.dat. some time this file is giving error .cannot delete the file undo.dat . I checked the location of the file there was no file called undo.dat .actually file was not created at the time of last restore . how to solve this?3) To solve above problem I change restore mode to with recovery and with norecovery for fullbackup no problem .but for differential backup it is giving error “chain is not complete” how to identify a chain of backup is complete. padmakumar

Case Study: Importing New Data Without Emptying Existing Tables

Robert W Marda — Wed, 08 Jan 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/importingnewdatawithoutemptyingexistingtables.asp

When to Use Dynamic SQL

Robert W Marda — Sun, 10 Feb 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/whendynamicsqlisuseful.asp

How Dynamic SQL Can Be Static SQL

Robert W Marda — Sun, 10 Mar 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/howdynamiccanstaticbe.asp

Dynamic SQL vs. Static SQL Part 1 Security

Robert W Marda — Sun, 24 Feb 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/dynamicsqlversusstaticsqlp1.asp

Exploring Deadlocks

Robert W Marda — Fri, 15 Feb 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/exploringdeadlocks.asp