Recent content by jazerr

I need to concatenate TEXT. The concatenation will ALWAYS happen at the end of the existing text. ALWAYS. I cannot make heads or tails of the UPDATETEXT stuff. Anybody can help?

I have a situation where I need to be able to run a SP and have a new DB created with the exact SAME definition. The best way I can figure is to write a set of SPs that script out the DB to .sql files, then actually run those files autmatically. I already have a SP that uses the sp_OAMethod...

I'm running MSSQL 2k. on Wind2003. I need a way to log all DB connections so that I can monitor performance during peaks. Is there a way to do this? External tools? Help. Thanks.

Okay, here goes... I have Exchange 2000 running in windows 2000. It runs just fine. We have a 3rd Party Spam blocker running on another machine. It runs just fine. We have Blackberry Enterprise Server running on a 3rd machine. It runs just fine. Here's the trouble. ALL Messages are sent to...

It will vary. Sometimes as many as 1000, but usually only around 50.

I have a question regarding Table Spools. I have a query that inserts data from a table into a table variable. On the insert, the execution plan says that 79% of my time is being spent on the Table Spool/Eager Spool. Given that the insert is taking like 8 minutes, I would like to cut this part...

I need to call it basically in the middle of another select. The purpose is this (and I didnt design it so dont yell at me): There is an ASP page that reads what we call a 'fieldspec'. This is basically a set of data that tells the ASP page what to do. Example data would be the tablename...

Well, this sucks. ANybody have a thought on how I might accomplich the same thing by other means?

Books online says I should be able to call an Extended Stored Procedure from a function. Here's what i am doing: CREATE FUNCTION page_getData (@table varchar(500), @field varchar(500), @pCode int, @db nvarchar(50)) RETURNS VARCHAR(7000) AS BEGIN DECLARE @result varchar(7000) DECLARE @sql...

I've got a SP that returns data like this: Goal Objective Objective Objective Goal Objective Objective Objective Objective Goal Objective Objective Each objective is related to the goal above it in the recordset. What I need to return is: Goal 1 Objective 1.1 Objective 1.2 Objective...

How does ErWin stack up to Visio? We have msdn licenses and so its hard for me to get them to spend money on other software without a DAMN good reason...

Mostly because there are SO MANY of them. I'm trying to implement something that our Dir. of Eng. spec'd up, but he has no knowledge of any of the implications of what he does. And given that I've managed to go 6 yrs without them, I dont really know why I need them now, since I write good SQL...

The table will ONLY be accessed via stored procedures. We have tons of error checking and whatnot in there. Would it be better not to use the FKs then?

Sorry, my funny terms.. I mean actually using Foreign keys rather than designing a table and just kind of [remembering] that this references that. Example: ALTER TABLE [dbo].[plah] ADD CONSTRAINT [FK_pla_parent] FOREIGN KEY ( [plahparentID] ) REFERENCES [dbo].[plah] ( [plah] GO

Looking for a good list of the benefits and drawbacks of using explicit foreign keys. Table scema is basically 1-to-many with FKs from several spots in the main table to various other tables. Anyone? Beuller?