Hi ,
Is there any way to Append data(in MSSQL Table) into text file in Dts.? (without running any .exe, .bat)
Regards
D.
Hi all,
I have a question about function PATINDEX()(in MS SQL Server), in Access has any function that the same. Or Are there ways to convert PATINDEX() function into MS Access.?
I want to...
SELECT * FROM vw_performance_evenement_1
UNION
SELECT * FROM vw_performance_evenement_2
gives this error:
"The text, ntext, or image data type cannot be selected as DISTINCT."
But e...
Hi,
I have the following function:
CREATE FUNCTION [dbo].[SomeFunction] (@Xml TEXT, @XPath VARCHAR(8000))
RETURNS VARCHAR(8000)
BEGIN
DECLARE @intNodeCount INTEGER
DECLARE @in...
We are running SQL Server 2000 SP1. A table purging sp (with a bug) went into an endless loop. There was a delete statment in the loop that returned an error status. The bug is: the script ...
Hi all,
I'm trying to trim down a database and things are not working as I would expect. I had a test table I was using with a few million records inside it. This was not needed anymore, ...
I have recently been looking into replicating my companies SQL servers, We are looking at expanding out servers capacity by adding more system to our network.
My problems is now, that we ...
Hello to my fellow experts!
Is it possible to use an Identity field when using an Instead Of Update trigger on a table?
At first I couldn't figure it out, so I gave up on using an Identi...
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?
Hello ...
I need to insert a mix of printable and non-printable characters using a SQL INSERT statement in SQL Server 2000 and MySQL like this:
INSERT INTO Parms (
[ID],
[Param...
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 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|...
