I'm using transactional replication on SQL 2000 and want to change my published database. I can use the stored procedures to add columns to a published article, but how do I add an index or ...
Hi,
I was using xp_sendmail to do this:
___________________________________
declare @query_string = 'select * from tbl_debt'
exec master..xp_sendmail @recipients = 'sho@sho.com',
...
Hi everyone. I have a qry I am writting. The gist of it is to output 60 or so columns in a very specific format--one such that each field takes so many columns. I have been able to do this t...
is anyone aware of a limit to the number of records displayed in a MSHFlexgrid? I'm using VB6 and ADO to query some SQL records. Is there some property I need to check on the flex grid?
I have a in house CRM Software developed. I have 3 tables with 500,000 records. I am redesigning the site and that include the Databases. 1 Database has the telephone number, address, name,...
Hi,
Ive got a problem with a select statement and the difference in collation between 2 tables.
Im rtrying to do the following
SELECT COALESCE(Artists.Description,Tracks.Description)
...
Hi,
I am working on a .NET application that creates a db and relevant users/roles. I load SQL template from the file and then substitute special string into proper values. What I mean is that...
Hi All,
If any one could correct my SQL I would be greatly appreciated. I am converting these queries from Access. I get the following error when I try to execute the following This was my ...
For the purpose of this question I have a table TABLE_A that has two fields
MyDate
MyTotal
I have a VIEW MYVIEW
Select MyDate, MyTotal, DATEPART(DateInterval.Week, dbo.TABLE_A.MyDate...
I need to clean out a database. I want to separte out 'old'-'unused' tables by checking when a table has had it's last update
I seem to remember that this is possible, but i'm at a loss of ...
I want to do a join query between data in an SQL server database and the data in a tick list on a VB form. Do I have to pass the tick list data back to the database via either an update or tra...
Hi..... All
Amit here. I want to import full database into oracle 9i from MSDE...
My (VB)application is running at client side using MSDE database. Now i want to...
I have a database wich I can backup manually via an ASP page on a website. This works fine. I use the following code to do the job:
fileName = MyDb
sqlBackup = "BACKUP DATABASE MyDb TO D...
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microssoft][ODBC SQLServer Driver][Named Pipes]Connection Open
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Er...
Question Title: Error handling in DTS
Author: nkushe
Points: 500
Date: 06/07/2004 03:32PM PDT
Can you please help me out .......how to use error handler in DTS.
how to handle er...
I get this error when I try to open up a table in Enterprise Manager. I CAN open it in Query Analyzer. Also in VS.net I cannot connect to the server exployer tables.
Any idea why or how...
This one is driving me nuts, I can't seem to figure out what the problem is, I have a function that creates a table from a list value, I would never store my data as a list in a column but I h...
Have a copy of Small Business Server Premium 2003, that comes with MSSQL... I cannot find the install for just the enterprise manager.
Where is it? Or do i have to install the DB?
thanks!
Any way to convert this query?
SELECT Transactions.Deposit, Transactions.ClientAccount, TransDate, DSum("Deposit","Transactions","ClientAccount=" & [ClientAccount] & " AND (TransDate < #" &...
i am going to create a DTS for periodic import syslog to SQL. Everytime when i import, my SQL will have multiple data since i import the same syslog file. I had tried to mark one of the colume...
I am using SQL Server 7.0 SP3.
I have a maintenance plan which backsup all of my databases to a share on a network server. Every so often their is an error:
Database name: Database Backup.....
I am running SQL Server 2000 on a Windows 2000 Server computer. It is infected with the slammer worm and I need to know how to remove it. Microsoft says that the installation of Service Pack...
Hi,
I am writing an asp page that will kick a DTS package to run under my SQL Server 2000(SP2). The DTS, CVSUpload, is basically a package to copy data from a CVS file into a table inside m...
I would like to know if:
1. There is a way to change IDENTIFIER_CASE in the spt_server_info table from Sensitive to mixed
2 To change the COLLATION_SEQ from 'charset=iso_1 collation=Latin1_...
I get this file delimited by |. There's about 36 of them and DTS is saying something about too many fields???? I'm trying to figure out how to use BCP instead but i don't see any way of spec...
