Hello, We have a high traffic web server farm where each server captures data and using c# bulk insert stores the data in tbDataDump (SQL Server 2005) almost every second throughout the day. I've been using a INSTEAD OF INSERT trigger to apply business rules to the data and then store t...more >>

Hi, I have 2 SQL Express 2005 Databases with a table that I want to synchronise between them. The rows will be minimal. I want to know the best way to do it. I am devolopiing in .NET as well. I could do it manually in .NET code but I thought there would probably be better way. One ...more >>

how do I query for size of image (bytes) stored in database field ...more >>

Listed below is Table A structure and sample data with the table. I would like to create a query that would output every third value of Counter field value, each value from the Counter value could have several values for the QMC_PK value. Listed below is an example output. Please help...more >>

Hi All, I am in a delima here. I have to a few backups restored from a set of backup file. The backup files have been removed from the drive because of some storage constrains... For some data comparison reasons, I need to figure out the actual date of these backup files that is used to res...more >>

Hello there due to performance problem i've checked the database action by the profiler. I've seen that there are a lot of actions named "Audit logout" which their duration is very big (10,000 and mutch more. there are some logout that takes over 100,000). what is this action and whay i...more >>

I hope I found the right news group. Please advise if I need to post to a different group. --- We are using the SqlXmlBulkLoad class in C# with success. Immediately after we call SqlXmlBulkLoad.Execute(schemaFile, xmlFile), we call Path.Move(xmlFile, newFilePath) but it fails as the xm...more >>

hi. i have this ASP code : mySQL= "INSERT INTO precos" mySQL= mySQL & "(ano,nm_mes,n_semana,cod_casa,inicio,fim,preco) " mySQL= mySQL & "VALUES (" & recs.Fields.Item("ano") & ",'" mySQL= mySQL & recs.Fields.Item("nm_mes") & "'," mySQL= mySQL & recs.Fields.Item("n_semana") mySQL= mySQL & "...more >>

Hello all. I must convert a number to an IP address. To convert it to an IP address, I must: 1. Convert the number to a hex value 2. reverse the hex bytes 3. convert the bytes from hex to decimal 4. Results in iP address Example: Program displays (-1139627840) 1. Hex value equals 0xBC12A...more >>

I'm new to SQL Server 2005 and have a question. I have a table with the following format: Columns: ID Col_A Col_B Col_C Col_D .... (Col_X) Values: 1 Yes No No Yes 2 No Yes No No ...etc For each unique ID, I'd like to get 2 values: The number of "Yes" values (Yes_Count) and the n...more >>

Hi All, I have a table I am trying to copy all the dta for a selected row into another table wih exactly the same table structure. What I have so far is: INSERT into mydestinationDB.dbo.mydestinationtable VALUES (select * from mytargettable where .....) mydestinationtable and mytargettab...more >>

I'm new to SQL Server 2005 and have a question. I have a table with the following format: Columns: ID Col_A Col_B Col_C Col_D .... (Col_X) Values: 1 Yes No No Yes 2 No Yes No No ...etc For each unique ID, I'd like to get 2 values: The number of "Yes" values (Yes_Count) and the n...more >>

Okay, this probably a dumb question, but what is the role of the [ ] square bracket delimiters is T-SQL syntax? They seem to be optional. But, I assume they would not be an option if there was not a reason to have them. I've searched through SQL Books Online and this news group and have not ...more >>

hi, i have the "std" and "other" schemas a user "u_std" -- for "std" schema a "u_other" -- for "other" schema and three tables : std.people --> Tom, Jerry other.people --> Lucas dbo.global --> 1,2,3 at this time, i can successfuly do this : - Select * From People ( logged with...more >>

Hi, I am new to Microsoft SQL. I want to use the following code to alter a table column. But it did not work. create table one ( a float NOT NULL, b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) exec sp_help one ; alter table one alter column a {NULL} , alter column ...more >>

I am installing an event logging software that uses SQL Server 2005 for the database. The software uses 3 databases (primary, failover, and archive). The archive DB is the one I need help with. I wanted to figure out a way to store the archive DB on a Buffalo NAS drive that has a 1TB capacity...more >>

why this asp code doesn't work on sql server mysql2="UPDATE precos SET livre = 0 WHERE inicio < " & Date() the inicio field is a datetime type ...more >>

I want to send a query result as PDF email attachment. Could any one give me an idea how to do it with out involving any client based code? I use SQL Server 2000 database. Thanks a lot for the help, abbamilkii...more >>

I am installing an event logging software that uses SQL Server 2005 for the database. The software uses 3 databases (primary, failover, and archive). The archive DB is the one I need help with. I wanted to figure out a way to store the archive DB on a Buffalo NAS drive that has a 1TB capacity...more >>

I have the following two tables in SQl Server 2005: TableA: ID Name A1 Cat1 A2 Cat2 A3 Cat3 A4 Cat4 A5 Cat5 and so on TableB: ID Value DocNum FormID A1 22 Doc1 Form1 A2 143.5 Doc1 Form1 A3 75.25 Doc1 Form1 A4 null Doc1 Form1 A1 null Doc2 Form3 A2 45 D...more >>

In a Visul Basic stored procedure...how can I designate parameters as optional and provide a default value?...more >>

How can I designate the schema to use when I deploy a CLR stored proc from the Visual Studio?...more >>

I am trying to create a stored procedure that will wrap around another stored procedure and pass in a list of jobID's to be used by the inside Stored procedure something like this: Outer SP (List of jobIDs, ie 27,42,99,105) This list will vary in length each time it is called Start ...more >>

Hi! i have following table called test_Date_accident : trans_code varchar 1 nullable claim_number varchar 20 nullable adm_date varchar 8 nullable birth_date varchar 8 nullable date_accident varchar 8 nullable error_code v...more >>

Hello, I need to create a database to hold documents information. 1. Basically, I need the following information for each document: Title, Description, LastUpdated, Category, Type, Url Should I create tables for Category and Type? And link them to my documents table? What t...more >>

Is there any way to store objects in SQL Server? I can get away with this using an array but id rather be able to dump an object in there.. at the very least i need to be able to store a linked list with multiple children. (hence the array) just for a frame of reference lets say there wil...more >>

I have attachment files (raw binary jpg's) that I base64 encoded and stuck in a Text column in sql server 2005. I am trying to write a clr vb.net assembly stored procedure to write these files to disk instead of to the database to conserve database space. The problem I've run into is that there ...more >>

Are there any disadvantages regarding execution plans for stored procedures that cross databases? We have a lot of similar stored procedures that we are considering storing in another database so that they don't slow down the listing of stored procedures in the main database. I want to know ...more >>

We have a batch table that stores information about when our packages ran and the PK in the table is BatchKey. The table looks something like this BatchKey PackageName Date 1 A 1/1/07 2 B ...more >>

How can I debug a SQL 2000 stored procedure? I have a long running loop that I want to check some values like you do in VS 2005. I currently use print. Any help is appreciated....more >>

Hi, I have a table structure like this ID ProductName Value 1 A 1.0 1 B 2.0 1 C 3.0 1 D 4.0 1 E 5.0 N...more >>

How to Export StoreProcedure ResultSet in to CSV format file using BCP Note: Here I need to call Result set StoreProcedure from another StorProcedure. ...more >>

Hi All I have table that captures measurements and I need to determine the count of records where the measurements is the same as the previous or next measurement. The SQL Server version is 2005. eg. Return a count of 1 as Reading 1 and Reading 2 have the same measuremenst. Reading 4 i...more >>

is sqlserver has any option like c has '\n\ help pls ...more >>

I have two server running on Microsoft Windows 2003 and Microsoft SQL 2000. Each server have 2 NIC cards, where the first NIC is connecting to the LAN and the second NIC is connecting to the other server for server alive checking purpose. These 2 NIC cards are configured with different group ...more >>