Hi Experts..
I have a Problem Like this..
Say I have a Insert Statement
INSERT INTO T(Cal1,Col2..)
SELECT ColX,ColY..
FROM T1
I know @@ROWCOUNT and @@ERROR Store Last Stement Results...
Hi,
The scenario is - I have to transfer n number of excel file data to sql server 2000 and the excel fields are varying. so different activex task are defined. excels results are queried i...
I am having difficulty trying to get an issue resolved. It seems simple enough but every solution I tried falied. I am a novice with SQL but have worked with Access for years. This is the situ...
I move my source data to a warehouse where i populate tables that feed the dimensions. When it comes to these two different storage choices, MOLAP or ROLAP I know the MOLAP choice contains all...
Hi,
how do we export out delimeter file from the data from database using bcp ?
I'm using this command :
bcp "SELECT * FROM "dbName"."Schema".Table" queryout xxx.dat -c -t , -r \n -SServe...
Trying to reinstall SQL Server 8.0 on Windows Server 2000 and receive the following error:
A service control operation failed for the MSSQLServer service: 267. The directory name is invali...
Hello, I'm getting an error in various places in my sql server... the error is
ERROR 7409: The Server Could Not Load DCOM
Is there something I can install to fix this? I tried to migrat...
Apologies for any syntactical errors below. I am writing my SQL from memory...
I have been fumbling around with this trigger problem for a couple of days now. I am trying to reference a fie...
I had an error on a MSDE client that I need help to understand is there anyone that have seen this before ?
Last Command
{call sp_MSdummyupdate (?,?,?,?,1,?,?)}
Error Message
The p...
I would like my datetime columns in my table not to default to "1/1/1900" but to nulls. Can I change my table definition or my vbscript code to acomplish this?
now i have two table
1st table
type_id type_name
4 a
5 b
6 c
2nd table
category_id category_name type_id
6 ...
I have an existing script that is used in testing to wipe out our database content in order to allow us to start from scratch (keeping tables in place). This script uses DELETE statements for...
I am having some connectivity issues with a new install of MSDE Service Release A. The Server has all updates from Microsoft as well as MDAC 2.8.
First I installed a named Instance of MSDE...
I am writing a medium sized application which does a lot of the same thing to a bunch of different tables. I'm using stored procs for insert/update/delete, but having issues finding a clean wa...
Hi,
When I ran my Perfomance Monitor for
SQL SERVER GENERAL:-USER CONNECTIONS Counter.
The average was 560.But my Sql server's "Maximum worker Threads" is configured for 255.
If i Inc...
I need to run a DTS, but from coldfusion pages. It's should be similar to the accepted answer on this question:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20450885.h...
I have made a DTS package that loops a directory for text files and transform them into sql server tables. Each text file contains data for four tables: They are organised like this :
MARA|...
The question title should suggest what is the problem.
This is very urgent as u may see that today is sunday and i am in office instead of home.
The above problem is in the table 'vch_deta...
Hi,
This works fine:
SELECT * FROM mytable
where fIndex = '12345'
But this times out:
UPDATE mytable
SET fEmail = 'me@mydomain.com'
WHERE fIndex = '12345'
Any ideas? ...
Hello All,
This is what I am trying to end up with. I am having some problems with the things mentioned on the second paragraph
When the web site user logs onto the site a connection is ...
Hi
Need help making this order by work.
exec spReadVisitLog should order by SessionID, seems to have no effect
Alan
ALTER PROCEDURE [dbo].[spReadVisitLog]
(
@From datetime ...
Hi.
If you set the size of tempdb, for example:
alter database tempdb
modify file(name=tempdev, size=5GB)
Is it possible to shrink it again or remove the size specification?
With us...
I am trying to create a linked server in SQL Server 2000 to Active directory using the following sql -
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'ads...
Hi Experts,
I have installed SQL software to my PC. After I start the SQL server, what should I do in order to create a database ??? I guess my question is : where is the terminal (or ...
Hi,
I have an OLAp cube with dimension Dates having hierarchy levels:
[Dt year], [Dt Quarter], [Dt Month], [Dt Day No], the last one has as property [date key] which is the actual date (yyy/...
