Search results for query: *

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...

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...

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...

I have a db with a bad design that cannot change. There are about 4million records in one particular table and every time any update/insert happens, it errors with the 'transaction log full' message. I'm wondering, in the database creation, can I specify that I NEVER EVER EVER want anything to...

I have a db with a bad design that cannot change. There are about 4million records in one particular table and every time any update/insert happens, it errors with the 'transaction log full' message. I'm wondering, in the database creation, can I specify that I NEVER EVER EVER want anything to...

I have a machine that has been having some trouble booting. It wasnt detecting the IDE drives correctly unless you fully powered it off then back on. So I went into the BIOS and loaded optimized defaults As soon as I did this, upon boot now, I get 'CPU is unworkable or has been changed.' So...

Got a doozy! ASP.NET State Service Keeps dying on me. When it dies, I get the standard 'error in '/whatever' application.' I Can't simply restart the service because once it stops, it just kind of goes away, and I dont know where to find it. The only way for me to restart it is to reinstall...

We have 6 webservers. All running Win2k Advanced Server. Identical installs/programs etc. Currently we are using MS: Application Center for only Replication. Unfortunately, this seems to be pretty flaky (for us). We are looking for a substitution. We need it to: 1. Manage file replication 2...

I have a query that gets me the table.column and id of indexes. The trouble is that I need to add a where statement to filter out all the ones that are not clustered indexes. SQL help doesnt tell me what to lookup to tell which ones are clustered. Anyone know? Here is my query if you need it...

I need a MOTHERBOARD with SCSI onboard. Does ASUS make one? If so, do they have one for AMD processors?

So, I'm in a bit of a bind.. I have a two tables. Each on its own server. There is a relationship between the two, but...they are on different servers.. I need to know how to link the two servers so I can successfully join the tables and get my data.. ANy help would be great.