for some reason when i deploy my C# application on windows 2003 occasionaly rdr[0].ToString() hangs where rdr is a System.Data.SqlClient.SqlDataReader. Is there a fix for this? is my visual studio.net out dated? ...more >>

Hi Folks I'm using SQL 2000 and migrating functionality from an Access/VBA frontend to the server. We have various (nested) triggers that fire stored procedures and call functions etc. many of which need to cycle recordsets. Being that @@FETCH_STATUS is global etc. I have as much as possibl...more >>

are System.Data.SqlClient.SqlConnection thread safe? can many threads share a System.Data.SqlClient.SqlConnection instance without any synchronization? ...more >>

/* I'm having a problem making a select statement to return the correct results. Here is an example of what I'm trying to do. Two tables: @TblNameParts which contains the master list of all the name parts and the MasterNameID which is a pointer to the master record. @TblCriteria which is b...more >>

Is there a way to identify which rows have just been bulk inserted in to a table? -- McGeeky http://mcgeeky.blogspot.com ...more >>

following, do I work with adp, do I use the safety of the sql server to authenticate the users, then in my front I do configure the access with my password, for the item connection of the menu, when do I distribute that front for each station, (do they use runtime) does the system always suggest ...more >>

This should be easy but I just don't remember how to do it. I have a table. I want to do a select statement query on it, and manipulate with the query results, such as looping every row of the results. How can I do that? Thank you....more >>

Hi, How can I list all the days YYYY-MM-DD in a specific year? I am trying to populate a table with all dates for a specific year. Thanks...more >>

Hi, We import data from our phone system every morning which is a tab delimited file. I'd like to automate this process. I'd appreciate some pointers on this. -- Thanks, Sam...more >>

Hello there I buckup my local database on some files. Afther the backup is done i want to move the files to the server, which is valume on my windows is there a way to move files from one place to another with t-sql? ...more >>

How can I retrieve the server name in MS Access? This is easily done in SQL Enterprise Mgr by running "select @@servername" but I haven't been able to find a way to retrieve the SQL server name in MS Access. Thanks, -Dock ...more >>

(Simplfied the table structure) I have 3 tables with data. On table is A_STATUS which has 2 fields, STATUSID (numeric) and STATUSNAME (TEXT). 1 OPEN 2 WORKING 3 CLOSED The other table A_MASTER has PROJECTNAME, PROJECTID and STATUSID (usually a 1 for OPEN) The last table is A_PROGRESS has P...more >>

I need to get a list of all the user tables of my database. When I execute the query SELECT Table_Name FROM Information_Schema.Tables I get back all my user tables, as well as the sysdiagrams table. I can exclude it of course from my result set using a WHERE clause, but I am concerned ...more >>

I want to bcp out the record set in a flat file. I am unable to write the correct script to do this. What I am trying to do is build a text comma delimited file by running a stored procedure say procTest. This bcp command will be executed in a nightly job. Please help. ...more >>

I have been encountering errors on a couple of my SQL Servers and in researching the problem I think that I may need to configure more MemToLeave space. I have not been able to find any articles that suggest how to go about calculating how much MemToLeave I need though. I use AWE to a fixed 5....more >>

Hi all Is there a way to close all open connections/sessions to my db at a certain time? I have a application that uses a web browser to access my database. At the end of the day i will have loads of open connections/sessions to my db. My plan was to run a job or script in the eveing to clo...more >>

Hello, I need to create a table that will contain one column which will hold unique Identifiers. I need to make it so that the data cannot be deleted once written/inserted. I know that there is a way to make a table undeletable. I just can't remember how. Maybe I need to add an extra co...more >>

I have three really small tables, which gave me a lot of headache. They reside in a MS Access database and a I am accessing them through ADO.NET(VB). Can't figure out how to make a "Select" query on them. These are the tables: 1St - "Transactions" TransactionID - primary key, autogen Transact...more >>

I'm experiencing different behavior in SQL 2005 when running UPDATE statements. For example, this query returns an error: update tblContact set userid=11847 where userid=11355 Msg 512, Level 16, State 1, Procedure Trigger1, Line 5 Subquery returned more than 1 value. This is not permitted w...more >>

A made a brokermethod just like in the helloworld_clr example in de service broker example dir in sql 2005. The brokermethod receives a message and tries to deserialize the message body which is a list of customer objects. But when I try to deserialize I get the following exception. It’s...more >>

I use SQL2000 and I have a query like this: select * from TabA where 'somecondition' UNION select * from TabB where 'somecondition' order by 'somefield' I need to limit maximun number of records from this query; problem is that maybe query A get a lot of records and query B get few record...more >>

I worked with Oracle/Sybase before, and I used PK/FK quite often, I had PK for every table. Since I started working in SQL Server, I saw serveral big applications (over 2000 concurrent users) don't use PK at all, they just use clustered unique index and there's no foreign keys either, the int...more >>

hi, I have a sql box under diff domain. I login as sqladmin mapped a network drive pointed to the dir that I need to copy the files. I created a job under command prompt---copy /Y z:\*'* \\server2\myfoleder\ If I run it under ms dos ----OK, but running it through sql server job, got this er...more >>

Hey all, I ran DBCC CHECKTABLE on a table and recieved this error: Server: Msg 8970, Level 16, State 1, Line 1 Row error: Object ID 71671303, index ID 0, page ID (1:107056), row ID 0. Column 'DLANG4' was created NOT NULL, but is NULL in the row. Server: Msg 8970, Level 16, State 1, Line 1 ...more >>

Hi, I am trying yo return a set or records by using a SELECT statement, the table contains a column called CreationDate. I want to add one more column to the resulting dataset (not to the table), that value of the column will be 1 if the CreationDate is 1 day before the current time, 0 ot...more >>

eBay Fraudsters and Phishers are being taken on by Bill and friends. http://fraudwar.blogspot.com/2006/03/microsoft-takes-fight-against-cyber.html ...more >>

Since Microsoft has remove the ability for developers to design in Access through ADPs in SQLS2005, I am going to begin my own discussion on why the Management Studio is poorly designed for developers. If I am in error on any of these points, please let me know because it could greatly improve ...more >>

I have several triggers on my tables that stores data changes into a separate 'audit' table. I just recently found out that there will be constant changes to the structure of the main table. How can I add the new fields to my 'audit' table programmatically? Adv-thanks-vance ...more >>

I need to deleted repeated rows from an sql server table. I inserted data into a table that has a primary key, identity column, so the rows aren't exacly identical because of the identity column. the rest of the data is sometimes repeated i have to eliminate those repeated records. I could solv...more >>

what is the actual length of the result returned by getdate()? When you set the mode Results in text in QA and run this , declare @s1 varchar(20) declare @s2 varchar(30) set @s1='no' set @s2='the' select @s1,@s2 select getdate() you get the following result -------------------- --...more >>

Hi, I have created an update trigger that updates another table's record in another server but it generates some error message : Server: Msg 7391, Level 16, State 1, Procedure Usr_Trig_GL53, Line 10 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to b...more >>

Hey I'd like to modify a field in a table when I export my sql server 2000 database to a access db. I would like it to be done between the moment I launch the process with the Export tool and the the moment the data is sent to the access db. Anyone ? Thanks by advance ...more >>

My domain host provides Windows hosting, including MS SQL database. Unfortunately it doesn't provide remote connections to their MS SQL server. I can see no method of retrieving my database structure, or the database populated with data, from the hosts control panel. I'm sure that I could u...more >>

Hi, I'm from Germany where we are used to work with specials characters like Ä, Ö, Ü. I want to retrieve all persons from table Person beginning with an A. Please notice, in Germany following query should retrieve all persons beginning with an A or the special character Ä: select * fro...more >>

Hi Im using Sql Server 2000 and it has more than three years of data total size of my Data Base is 19GB in that one table alone i have 40 million records. Im using ASP.Net C# as front end. Now a days my system hangs very ofently and once i restart SQL Server it works fine for another a week...more >>

I am relatively new to the SQL world (mainframe background) and I have been experiencing a strange anomaly with a table trigger. When I have two updates that are made in quick succession to a table that has an AFTER trigger on it, intermittently only one of the triggered updates are being w...more >>

Oracle have released a free download to enable non-developers without application development experience to quickly build professional web enabled applications. The tool oracle as released for download at this URL: http://www.oracle.com/technology/products/database/application_express/index.ht...more >>

Hi all, I posted this yesterday (thanks Uri Diamant), but there has to be a better solution. I have a SQL 2005 instance with 4 dbs in it. In three databases, the structure is identical (data is from 3 seperate companies). Is it possible to access any of the three databases, from sprocs i...more >>

Hi, I am using DBCC Log command to see all the logs in online log file. After checkpoint these logs disaapear from the dbcc log result as expected. But when I open the .LDF file using tools available in market to read the ..LDF file, I found that logs before checkpoint are still there in .LD...more >>

Hi, I have seen some strange behavior of SQL Server, but I am not sure whether it is expected or not. I had performed large no of operations on about 500 tables in a single transaction, due which size of LDF is grown to around 10 GB, but when I took transaction log backup, backup file size...more >>

When suddenly the power is off, So a lot of my data are lose. But why the missing data exactly at table master? Though according to my logic, data which ought to easy to lose is data in table transaction. But the fact, why the missing data exactly at table master? Can U explain it to me? Th...more >>

Hello SQLServer-specialists! I'm running a database which contains on table, where the customer is allowed to import data into. This table also has a column, which the customer should set to his name, so that you know who imported the record. The problem is, that the customer is not restric...more >>

Hi, Is there any sql command to retrieve a particular row by specifying its row number. ...more >>

I would appreciate any ideas on this. (I posted this to an ADO group earlier but have not seen anything back). I have 2 disconnected ADO recordsets. At the db, these refer directly to tables 1 and 2. Table 2 has a primary key matching Table 1 and a foreign key set up for delete and update c...more >>

Hi , In BOL when creating a trigger , it says IF UPDATE(column1) has been updated then it'll return true , how shld i be checking for an insert instead ? i have tried IF UPDATE(Column1) update statement ELSE insert statement --> but it seems not able to come to this part have also ...more >>

I have 2 files with its same name (at folder C:\a\ and C:\b\, both Name files is SData.mdf). I wanna access the files in enterprise manager at the time. Can I do it? Because I wanna copy a object (table, store procedure, etc) from C:\a\Sdata.mdf to C:\b\Sdata.mdf. How to do it efficiently? ...more >>