Hi,
I have a server with the following configuration and I need help to configure memory allocation on SQL Server 2005:
- Windows 2003 Server Standard Edition
- SQL Server 2005 Standard E...
I need to report the AR balance of customers. However, some but not all customers have a Parent company. I need to report a total for the parent company when there is one.
Consider these two ...
I have been trying to access an SSRS report via URL and cannot get my date paramenter to pass correctly. I have accessed other reports via URL where no date functions are used as parameters or...
Hi,
We are having too slow response times for a simple count on a fulltext in SQL Server 2005. Even using the most simple query on a good server (64 bit Dual Opteron 4GB Ram with high speed...
Greetings good people,
We are moving from Oracle to SQL Server and are in the process of converting our databases from oracle sql server.
I have not done this before and we have run into...
I recently migrated three databases from one server to another. After doing so I migrated the maintenance plans as well, via a restore of the msdb system database. I then went through one of t...
I'm trying to assemble an insert statement inside a stored procedure:
The value of @move_guid is equal to the output of newid()
The procedure can compile without errors, but when I try t...
I need a way to check a string to see if it contains a mixture of alpha and numerics - also need to check if one is just alpha or just numeric - whichI think I can do from the below - but not ...
My database's transaction log keeps filling up, crashing my site. I also don't have a solid backup plan in place.
I would like to create a scheduled task to backup my database. I'd like to ...
Hi.
There are about a million records spread across three tables. primarily the data is coming from the data_table - with primary key as ID. This is joined with another table (smaller) for so...
I have a table with 5 columns and 5 rows as below:
Comany HeadcountStart Starters Leavers HeatcountEnd
------ -------------- -------- ------- ------------
AAA 500 ...
I need to collect all notes taken with in one hour of last contact with a customer,
our notes system allows for multi lines to be added to the database for one issue.
I did a sub-select to g...
Hi experts!
I had an issue where I needed to rename variable / text in all stored procedures where found. I looked everywhere (i think) for a solution and could not find one so I came up wi...
I develop against a test database and then move my changes to a live database - as probably do 95% of the rest of you out there! Back in the good ole days in previous versions of Enterprise m...
I built a BCP import utility that utilizes a format file, "Format.xml." (See code.) The utility and the format file worked just fine until I added a primary key column (RTImportID) as the fir...
I'm lost trying to do this and not having any luck. Is there a good tutorial out there or do any of you know how I can connect my MSSQL Server 2000 to a Adaptive Server Anywhere 9.0 using ODB...
Hi All,
I have a trigger that in some cases will execute a roolback. I know that the rollback is successful but an error message is generated:
Msg 3609, Level 16, State 1, Line 1
The tr...
Have 2 node cluster that has data and quorum on SAN that is being replaced. We have moved the data files to new SAN in the past and pointed to new SAN as described in post 17091337 and had su...
Daily, XML data from a provider in a format where one node contains the column names and subsequent nodes contain the data (See attached code snippet.) Every data element is merely named "Colu...
Yes I am trying to write a stored procedure that will use my primary key and return the same value on update
Primary key is PKid
Group West
Os Compliant 2500
OS Non Compliant 1500
Total ...
Hi since it's not possible to include parameters in an openquery I was wondering if there's a way to write a function that accepts parameters and construct and execute an openquery on a linked...
I am working on a front-end for a SQL database. I'm using VB 2005. The SQL server is 2000. I need a solution for a user to click on a button to bring up a file open window. Then the user w...
hi,
I have sql server 2005. I am trying to write a procedure which will automatically send an email on a particular date. I am following one of the links (http://forums.asp.net/t/981809.aspx)...
Web server is using the Index Server for a search engine and site map. Can write asp pages that query the index server with no problems, but I want to see what else is in the table.
On our...
