Hello, I am getting this error: Cannot create a row of size 8068 which is greater than the allowable maximum of 8060 When updating/added row to SQL 2000 on Windwos 2003. Thanks for all you help, Jack ...more >>

-- Bemærk venligst, atHi I'm building an application where the data structure is hierarchical, I have used 5 tables related with each other throug x.nodeid=x+1.parentid down to 5 levels. Level5 is containing an extension number (serie). The point here is to give the user a tool to...more >>

hello all, I am tring to build a form building tool inside the database. I know most of you will say put it in the application layer, but I would like to keep this text formatting in the database so I only have to write the function once and our 2 unix server, and one windows server can all...more >>

i created a query which insert rows in to another table, and send mail to the recepient using sql mail task. the work flow Success is sending mail even 0 rows inserted into the table. Is their any way i can send mail only if row insert in to table? -- Message posted via http://www.sqlmo...more >>

Hello, I have the following problem... I am musing ADO.NET with SQL Server. I have a table that stores events that are linked to different tables.. for example, lets suppose that I have the following tables : Airplanes, Cars, Trains. Each table is different, however, events produced ...more >>

When I do something like this: SELECT * FROM someTable FOR XML AUTO, ELEMENTS for instance, how can I use returned XML string within the SQL server, that is, pass it to a stored procedure, for instance, or fill in some variable with it? Mike -- "I can do it quick. I can do it cheap. I...more >>

I just read this quote at DevX.Com "It's generally better to use the stored procedure option to perform the transaction against the database rather than initiate a transaction on a Connection object. When possible, you should isolate transactions to the data tier, because it's the DBMS that...more >>

When creating a Stored, I noticed that SQL not accepts when placing the value of the field as True or False. Is being True like this same to 0 or equal to 1 and for the false which value does he take? ...more >>

I am needing to recuperate a database .mdf for mine it conspires. Would anybody know how I make that? ...more >>

I just read a good article on DevX.com entitled "Store and Retrieve XML-based Business Objects with SQL Server and .NET" and I decided to give the example a try. Everything worked fine, I just want to take it a baby step further. Here's the article: http://www.devx.com/dotnet/Artic...more >>

I got an error: "Cannot insert the value NULL into column 'PreScreenAmount', table 'ccuDev.dbo.LMA_LoanInfo'; column does not allow nulls. INSERT fails. The statement has been terminated." Within the table I created this field as: PreScreenAmount DECIMAL(19,4) NOT NULL DEFAULT 0 Should ...more >>

I would be very grateful for advice or suggestions for the following problem. I have had no problem with Full Text Search in SQL2000 on my PC under XP Pro using the Developers Version of SQL 2000. However, I have created another copy of the same relatively small (100mb) database on a notebook...more >>

Hello, I would like to insert the value of an identity column into an other field during the same insert statement and not by using a trigger. Sample Table CREATE TABLE Test (INT DocumentID IDENTITY(1,1), DocumentParentID) Sample statements NOT working but to indicate what I would li...more >>

I was wondering if I could stop certain applications from connecting to the SQL Server. For instance, under Management (Enterprise Manager), I find (say) application "XYZ V 1.1". I want to stop this application from connecting to the SQL Server in the future (deny the connection when it trie...more >>

Hi all, I was wondering what the best SQL code is to find all records in table_A where they do not exist is Table_B I use select a.* from Table_A a left outer join Table_b b on a.ID = b.ID where b.ID is null Is the the most efficient way to do this or is there better codsde for this? T...more >>

Hi, Apologies if this is not the correct newsgroup - I've also posted this message to the microsoft.public.dotnet.framework.adonet and microsoft.public.sqlserver.datawarehouse newsgroup... As part of a datawarehoue application, I have a Windows service which iterates through a mySQL Data...more >>

Can someone please help on this issue and tell me how to amend this code: <WebMethod()> _ Public Function GetRecord(ByVal anyname As String) As DataSet Dim adapter As New SqlDataAdapter Dim result As New DataSet adapter.SelectCommand.Connection = Conn ...more >>