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...
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...
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?
I am running a Netgear:mr814v2. Sofar it has worked great. No problems to report. I recommend trying it to everyone..
Now for my question...
A friend just moved next door, and I want to allow him to use my dsl. Trouble is, the wireless signal strength in his house is pretty bad and even flaky...
I am performing a bind to another server inside a Stored Proc. This works well. But I need to make sure that I add a check to find out if the server I am trying to bind to actually exists.
Does anybody know of a way, in a Stored Proc to check the existence of a server that I wish to bind to?
I've got a COM+ package running on a Windows 2000 machine.
When I install a proxy to it on my Win 2003, the proxy appears to install fine, but no communication seems to be allowed.
Any ideas why?
I'm forced to Migrate a 2000 web cluster to 2003. I need to set up the servers in a cluster (for replication and whatnot).
The machines are called WEB01-WEB17. I am using Windows 2003 Standard on all of them. I need the cluster to be initialized on WEB01.
When I go through the 'New Cluster...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.