Hi, I have written a query to pull out data and format it to a client's requirements, however when I try and export this data to a .csv in the dts wizard I get an error about transformations required. The transformations dialog only shows three columns!! (id, title & dob) Can anyone tell me why […]
2002-03-15
We have 2 servers set up for replication. These both have 100 MB network cards for general network traffic. We have also set up 1 GB cards in each of these servers designed to let just these 2 servers talk to each other at that speed. We envisioned replication between these two servers being the […]
2002-03-12
2 reads
We have a necessity to call the Rand() in a UDF.But as per SQL Server 2000, it refuses to allow the usage of RAND(), as it is non-deterministic. Hence, we tried by using a stored procedure which has a call to the RAND() and return the subsequent random value. This again fired back, as there […]
2002-03-11
13 reads
Our merge replication is failing with the following error: The process could not allocate memory. I'm wondering if this indicates the memory on the server is all used up. I can't check and don't want to wake up our Network Engineer (who can access that computer) this early unless that is the most likely reason […]
2002-02-21
1 reads
Hi, I have a problem with OPENXML - loading data into a table, a character field that sometimes contains leading 0s loses the 0s! The XML is passed as a parameter to the stored proc and code is: EXEC sp_xml_preparedocument @hdoc OUTPUT, @bstrXMLStream INSERT INTO @tCat SELECT * FROM OPENXML(@hDoc,'/ROOT/FUN',1) WITH (CC INTEGER, C CHAR(16) […]
2002-02-08
5 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/funny47.asp
2002-02-07
3 reads
I am trying to backup to a share on another machine. I have changed the SQL agent to run as a user with permissions for that share on the other machine. It still tells me it can't reach it. Does SQL Server have to run as this user too? When I run the maintenance plan […]
2002-01-19
2 reads
Hello room, I just upgraded my machine and forget how to install SQL2000. My old machine is win98SE and SQL2000 (theorically incorrect, but it still work). I remember I did download a service pack or something to make the SQL2000 runing on that old machine. Recently I put an winME version and new hardwares on, […]
2002-01-11
3 reads
Did anyone can help me....I would like to set SQL Server Agent to run a job automatically and notify n=me through e-mail but I got a problem during setting up the SQL Server Agent which is the error is :- ERROR 18025 : xp_test_mapi_profile failed with mail error 0x80040111 regards, kenari kenari7305@yahoo.com
2002-01-10
4 reads
i am trying to import data from MSExcel to SQL 7.0 database. i have to import data from one spread sheet to different tables in a database having foreign keys etc. How do i do it? suggestions please 🙂
2001-12-18
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