I created a DTS package to load all the event logs from many different sites. What I am trying to accomplish is figuring out how many computers are at specific sites based on received event logs loaded. The issue I am having is my query below is doing partially of what I want. I get all the sy...more >>

i want to try to use stored procedures to allow updates to a table; but i've never seen a reasonable way to do it. The syntax that someone would call is: EXECUTE UpdatePatron @AccountNumber=12345, @ZipCode=28570 or EXECUTE UpdatePatron @AccountNumber=12345, @Lastname="McDonald", @Res...more >>

I'd like suggestions about the security of storing any type of text in a varchar(MAX) column. I have web browser based application with one section that is basically Notepad. People can paste what every kind of text they like. There isn't any texturizing on my part. It goes into a varchar(MA...more >>

Hi I am a newbie with vb.net. I am working with vb.net 2.0 and sql server 2005. I am trying to get the return value from my insert stored proc.Does anyone know how to do this? thanks E ...more >>

I set the datefirst to the same MS SQL Server 2000 from two computers at the same time. For example, on computer A, I set the value with 'SET DATEFIRST 1' and on the other with 'SET DATEFIRST 2' on computer B respectively, then execute 'SELECT @@DATEFIRST', computer A returns 1 and computer ...more >>

I`m not multi posting, my messages end up as replies to others nd can`t figure vout why, so here again, with profound apologies. I have a table that contains the start and end datetime of a series of transactions TransId Pk Int Channel Int can be 1 2 3 or 4 Started datetime Ended datetim...more >>

I have a table that contains the start and end datetime of a series of transactions TransId Pk Int Channel Int can be 1 2 3 or 4 Started datetime Ended datetime I need to obtain the number of transactions,min duration, the max duration, the average duration of the transactions, and I nee...more >>

ALTER PROCEDURE TestSps @doc NTEXT AS DECLARE @idoc INT EXEC sp_xml_preparedocument @idoc OUTPUT, @doc SELECT * FROM OPENXML (@idoc, '/ROOT/Customer',1) WITH (CustomerID varchar(10), ContactName varchar(20)) GO DECLARE @vc1 nVARCHAR(100), @vc2...more >>

I have a table with an id column and a date column. Each id can have multiple dates associated with it. I need a query on this table that will return 3 fields: id, start date and end date. So what I am trying to do is turn the date column into 2 different fields dpending on their val...more >>

Here is the situation: I have SQL server express 2005 installed on my pc as instance SQLEXPRESS. I have created a Visual Basic applicaion with the following as connection to the SQL server express 2005 running on the same PC: *****************************************************************...more >>

Hello - I am having a problem with 2005 seeing the 2005 instance of Sql Server. I am also running 2000. With thanks to Dave, Erland and Roger (post of 1/12/05) and a little fishing on my part, I realized both instances are named the same. (I was really tired when I installed it!) Is...more >>

Having a little problem coming up with a solution for my email newsletter management application. I have three tables: emails --------------------- emailId int email char (100) sentEmails --------------------------- sentEmailId int newsLetterTextId int emailId int dateSent da...more >>

Hi, I wanted to know if there is a way to modify the system tables in SQL Server 2005, and if yes a way to audit these actions. I tried selecting from the system tables (using a DAC connection), it allows me to do so, but the profiler doesnt report on this action. Table queried on :...more >>

Newbie needs help with basic query... I have two tables each with a numeric field containing financial data. (The numeric field has a different name in each of the two tables if that matters.) I need to select a subset in each table, sum on the numeric column, and then combine the two sums...more >>

I try to make a view index but I can't and it gives be the bellow error: ------------------------------------------------------------------------------------------------ Create failed for Index 'index1'. Additional information: -An exception occured while executing a Transact-SQL statement or ...more >>