Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
2001-10-18
10,360 reads
The pretty much same code sends right e-mail from ASP page, but this, if sent from SQL server, cuts Body for the message. I did verify that SQL sends right query (to MTS?) using SQL Profiler. Please help! Declare @From [VARCHAR](8000) , @To [VARCHAR](8000) , @Subject [VARCHAR](8000), @Body [VARCHAR](8000), @Importance int , @MailFormat [BIT] , […]
2001-10-17
2 reads
When I run A DBCC Memusage on a 6.5 server it returns an Object ID of 99 using a lot of the data cache. The example shown in Books Online also returns an object id of 99 BUT I can't find out what Object id 99 releates to. Can anybody educate me? Many thanks in […]
2001-10-17
7 reads
Hi there- newbee question for ya. I have an SQL server with IGB RAM that was recently upgraded to 2GB but SQL still hogs all the RAM for itself. I have been told I should reserve 15% for the OS but I don't know how. Its SQL7 running on WinNT4. Thanks, Kevin Reynolds
2001-10-17
4 reads
Hi ! Here are the log of an DTS execution : "DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copier les données de Résultats vers \\Wmp-pczno\sap_transfer\WMDBSAP.txt Étape DTSRun OnError: Copier les données de Résultats vers \\Wmp-pczno\sap_transfer\WMDBSAP.txt Étape, Error = -2147217887 (80040E21) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File […]
2001-10-17
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
15,842 reads
I am developing a data-warehouse and trying to populate the data staging area from an Informix database using SCO Vision ODBC drivers. I've created the DTS packages (meta data services packages) and set up a job to run them sequentially every night. Most mornings, I come in and the job seems to have got stuck. […]
2001-10-15
I have a database for sports results. I have a table that holds entry details (Name, Class, Number etc) and a table for results which can be considered as just linking a given result to a given entry. Each competitor has more than one run and the best N runs count. I know I can […]
2001-10-15
10 reads
Hello, My SQL Server 7 is not having any service pack. Im planning to upgrade it to the latest service pack released. I did go thru the microsoft site, but i also heard that there are a few bugs in the sp3 installation. What I want is, a step-by-step procedure to be done to install […]
2001-10-15
2 reads
Hi, I would like to know how do i remove the publications from the tables which are already published.. Details of the problem : when i configure replication from a local sql server to a web server.. every thing works fine.. Now at a point of time i want to disable this replication process..(infact remove […]
2001-10-15
7 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers