I'd love some suggestions to replacing Erwin with something cheaper.
It needs to handle Micrsoft Sql Server. MS Access and Oracle are nice to have's but not in the lest bit mandatory.
...
Using xp_commandshell how do I just get file/folder names without the attributes and the lines without the Drive volume information into a table?
I'm trying to something like the following:
Declare @myCommand varchar(255)
Set @myCommand = 'copy F:\Folder\SubFolder\file.txt F:\Folder\SubFolder\my archive\file.txt'
EXEC xp_cmdshell ...
Currently this is a query I run to calculate the Sales % on a particular entity and account, it works fine and only retrieves a single line of data.
SELECT [entity], [account], [Jan], jan/(...
hello
anybody has simple example of acheiving 'powerful' heirarchy table?
i tried with success a method, where in a column stores the whole heirarchy in every record
like
id userid ...
I have 3 columns that contains lot of spaces. I want to remove all extra spaces. For example, if I have more than 2 spaces separating between words, I want replace it by a single space. These ...
I have a question. I am trying to create a SOAP Web Service using MS SQL Server 2000 with the SQLXML 3 sp 2 extension.
I was able to configure and run a template/XML based example without ...
Hi All,
I have developed a database on my local computer using MSDE. When I move the Database to the production server (by performing a 'backup' locally, and having the SQL admin do a 're...
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 ...
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...
