I applied SP2 on Win2003 Server for the SQL 2005 Standard.
Why do I get
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corpo...
I have a function called check_sitrep_tree_func which calls a stored procedure called "Up" (which just displays something). When i execute the stored proc (exec Up) it works fine. But, when I ...
Hi All,
I have an old MSSQL 2000 installation from a previous admin setup here and no one has the SA password. Does anyone know of any utilities to extract/find the SA password, or am I SOL?
I've got something that's probably simple, but I'm still not that great at SQL...
Sample query:
SELECT SUM(field1) + SUM(field2) AS 'Total' FROM Table WHERE field3 = 'something'
Proble...
Hi,
I have a column in our call management database called ElapsedTime and it is the number of minutes an action took its datattype is an INT. For example in the call management application...
possible or impossible?
we have a database which previously was understood to have backups on it through the inception of the server. we found out today after having dropped tables that th...
I have table A with two columns
Location_ ID, ITEM_ID
1 location many items (min 1 , max 5 items per location)
In my report I want to concat all item_id delimited by ',' by each loca...
I have this below query running in SQL+, I need to parse out the domain name from email address, how do you convert the following statement to run in MS SQL 7? I keep on getting error message ...
A user has been trying to print a report from a website and she gets a "unable to load client print control" error message.
We are operating in a SQL 2000 environment. We are running Windo...
Got this error when I tried to restore AdventureWorks sample db
Could not find row in sysindexes for database ID 7, object ID 1, Run DBCC CHECKTABLE on sysindexes.
COuld not open new dat...
I want to insert values and fields into a table, is that possible? Here is how I started:
INSERT INTO dbo.tblNonMon_Daily_Trans (PCRACT, Transaction_Code, SubTrans,
Term_id, Op_Code...
Hi,
I'm quite urgently needing an SQL statement which removes the primary key constraint from a column while leaving the data intact.
Can't quite make heads or tails of the MSSQL syntax ...
Experts,
I have been on this for days. The primary key in my database is used as a product id, so it is not set to autoincrement.
I CAN UPDATE other fields but not the prodid,
how do i...
In an sp i'm writing, I need to convert an integer value to a string. I usually do this with the cast() function. But this time, I need to left pad the string with zeros. So how do I do this?
...
Hi Guys,
I have a serious problem regarding my MSSQL2000 Server during the installation. I actually installed it before, but after removing it, when I tried to do the installation again a s...
To try to resolve deadlocks in my DB, as per recommendations in BOL and MSDN, I'm going through my transactions, and, in cases where they:
1. select rows from a deadlocking table
2. do lo...
Is there and LDF and/or MDF viewer?
There are 2 table, table "user_table_a" and table "user_table_b", which are the same except that table "user_table_b" has 1 more column than table "user_table_a". I use this SQL statement to c...
Hi,
I'm new to Transact-SQL so just wonder is it possible in MsSQL to execute a stored procedure inside another stored procedure and save the returned recordset into a temporary table.
I have two Columns that I need to take the Max value of and limit on the higher of the two.
I was trying to do this:
SELECT MAX (COLUMN1, COLUMN2) AS EXPR1
FROM TABLE
WHERE EXPR1 > 100
...
Hello,
I am trying to to execute the following query in MS SQL Server:
SELECT tblProducts.ProductName AS [Product Name],
SUM(tblOrderDetails.Quantity) AS [Quantity Sold],
SUM(tblOrder...
Hi Guru:
I work with Oracle but is completedly new to SQL Server. I was required to create database and restore from a dump file (I would think that it likes oracle's import). The dump file...
I have a table named Table1 contains records like the following,
field name data type length
------------ ----------- --------
field1 nv...
Hello,
I just got done building some reports on my report server (local workstation, windows xp) that runs a report from a database hosted on a server 2003 box with SQL 2000 running on it.
...
Alter table tbl_name alter column [col_name] int IDENTITY (1,1) NOT NULL
gives me Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'IDENTITY'.
col_nam...
