I am having problems with my MDSE sql 2000 database. When I run a report some of the information is missing. The information is there for some projects but not for others. I am using the same ...
Hi, I have a table of key words (that change) that can appear in an address field to indicate whether the customer has an address that is only accessible by boat (probably a cottage). I would...
I am running MDSE sql 2000 and trying to use the DBCC command. The system return the reeor
not recognized as an internal or external command.
What can I do to find this command?
I am running sql server 2000 and have a function call dieing on me. Nothing is recorded in the logs but crashes my site. It is a random event hard to recreate. I would like to try and log t...
How can I avoid the "login to database" prompt when staring Sql Server Mgt. Studio.
thanks,
bmutch
I have a Stored Procedure where I use the same string value several times.
I'd like to replace these with a constant name. For example,
rather than
WHEN Exec_Code BETWEEN '0600' AND '1999...
I have a client server application - ODBC client to SQL Server. The database is experienceing out of control memory growth (paging files) and has to be restarted frequently.
I believe that ...
We'd like to swap out our SQL 2000 server machine. The new machine is built and has SQL on it... There is just one database that I wish to move (it has stored procedures).
This is a Windo...
Hi Everyone,
I have this script which was running fine but then now its giveing me an error
" (136 row(s) affected)
Server: Msg 8134, Level 16, State 1, Procedure LTS_STYLE_PERFORMAN...
Is it possible to restrict users accessing sql server via excel without adjusting permissions? Our users are all memebers of the admin role. Thanks.
Hello everyone.
We had an incident where a database maintenance job ran much longer than normal and caused us to miss a bit of production.
Management wants me to write a job that we can ...
Hi all,
I have a very perplexing sql problem. i have a query like this:
SELECT TOP (100) PERCENT SUM(ISNULL(dbo.tblApplicationFund.App_fundamount, 0)) AS fundAllocation, dbo.tblApplica...
How do i use a for each loop in SQL ? I need to do multiple inserts based on a SELECT query..
SET @EmailID = SELECT Email_id FROM products where CustomerID = '10000'
INSERT INTO tblAlert...
A query I was using to generate a set of results has suddenly stopped producing results and I don't understand why.
I have 2 tables - Opportunities and Quotes. Each table is related to a c...
I have set up a mirrored database, with no witness, on high performance. I am not sure, if the principal db fails, how to failover manually?
I need the best way to present data for reporting when the raw data is a log of status changes that show the jobID, status, and date the job was set to the status shown in the record. The repo...
The ASPNET team chose to use GUIDS as identifiers in the ASPNETDB schema. Can anyone tell me why? All of the other information I can find seems to indicate that they would have been better off...
Hi
I am creating a cognos report that uses date prompts, when you run the report you enter a start date and an end date. What i would like to do is make a calulation on the results of a que...
We have our database on sql server 2000. We are having some new software implementation and as part of that we are supposed to provide some data to the new vendor from our sql database.
We ...
I am writing a report for the local sheriffs office here and I am trying to find a way to show evidence items that have been returned from FDLE agencies. Here is what a sample set of the tabl...
Good Day
Experts:
What is the best way to condition on a Select query is a Stored Procedure to determine whether to process code or not?
Let's say I have --> Select EngineHP from Motor...
I have a SP that's working fine and has a where clause to use data dated yesterday:
WHERE
dbo.vActiveSRs.Status = 'Closed' and dbo.vActiveSRs.ClosedDate >
CONVERT(datetime,CONVERT(va...
Do I have to stop SQlserver/sqlserver agent services before changing the password??
I have a datbase where the T-log is 10GB. The drive is only 13GB, so it's filling it up.
I have set Enterprise Manger to execute to shink the T-log to 1GB, the file data contains 550MB of d...
Hello:
I'd like to run a query in SQL View, and have a recordset returned, then add a constant variable to that set for each Company code. Would I use append function?
Like:
SELECT DI...
