Hello,
Can someone tell me where to download the client side activex control for the print button that was added with the new service pack?
Some pcs prompt for it automaticly, but others...
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,
I am getting this error when trying to restore and not sure why:
---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
The media family ...
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...
when i write Store Procedure
use by Linked Server Connection
CREATE PROCEDURE MyProc as
Select * from [LinkedServer].DBname.dbo.Mytable
go
when app...
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...
Hi,
The log file will not shrink in size.
I used the following commend (to no avail):
CHECKPOINT
GO
DBCC shrinkfile('DBNAME', 1)
GO
BACKUP LOG CAM WITH TRUNCATE_ONLY
GO...
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...
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...
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 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...
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...
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 ...
I have a table named Table1 contains records like the following,
field name data type length
------------ ----------- --------
field1 nv...
Is there and LDF and/or MDF viewer?
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,
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
...
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...
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 ...
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...
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...
I run MSDE on a Windows XP Server and i found that my database was marked as "suspect" by Enterprise Manager and its icon become gray.
I detach that database and try to re-attach it but there...
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 experts, I created a script on sql server 2005 to make my database to sql server 2000, so i got the script and i run it, anyway, now i have the database to sql 2000, than i try to attach on...
