Keyboard Face

Is it possible to execute a stored procedured within another stored procedure? According to this thread, it appears so. I’ll have to try it out.

Within a stored procedure, you can execute a stored procedure via EXEC OwnerName.StoredProcedureName. Check SQL Server Books Online for details on executing stored procedures. If the stored procedure returns a result set, then you can:

CREATE TABLE #Temp…
INSERT INTO #Temp…
EXEC dbo.SP1 @parm1 = 10
…
DROP TABLE #Temp

Tara Kizer
aka tduggan

If you need a good erudite excuse: http://www.red-gate.com/excusegenerator/Excuses.aspx

Microsoft is celebrating the launch of Visual Studio Express by offering it for free for the first year. This includes their Visual Web Developer 2005 Express Edition. This is a great light-weight tool for .NET 2.0 development. I’ve been using the beta version of it for the past couple of months.

Here’s the link to the download site: http://msdn.microsoft.com/vstudio/express/

I run several SQL Server 2000 databases that have lots of updates to them every day. Inevitably our log files grow very large. I discovered a long time ago that you could shrink them by backing them up.

All that was left was to make it back up every day so that it never grew too big to backup. Unfortunately, I let it grow to big and I was no longer able to back it up because it was now 11 gb!

Finally, after much searching, I found this tool that shrinks your log file for you using the SQL-DMO object.

Here you go: http://www.codeproject.com/database/ShrinkingSQLServerTransLo.asp