I have a table "Alert" which has millions of records, i need loop thru all the records using cursor and update the records. While running the batch, the table is locked. -- Sakthivel SQL Server Developer INDIA...more >>

I am new to MS SQL. Can I write a batch job which will execute the sql statement nightly? How do I do this? ...more >>

I need help building a query. I am building a gridview control that should display a row for each day of a selected month. On each row on the gridview, content entered by a user would appear for that day. I have two tables, Dates and CandidateSchedule. Dates has all dates for the next two y...more >>

Hi Is there any Sql command, system procedure or function which could forcefully close all the connection open on a database. I need to restore/delete a database using sqldmo. Many of the times the method fails due to the connections that are open on that database. Regards Usman ...more >>

What is a right way of dealing with periods of datetime to find out if they have inner join? Thanks ...more >>

What I am trying to do is select the max date from a column and compare the day of that date to the day of getdate. Any suggestions? So if it is May 03 I want to make sure that the 03 is the same in my max date. I hope that makes sense....more >>

I got interested in a post I saw a few days ago. http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_frm/thread/f58090fb59ef879f/a242e4eeb2ae00fd?lnk=gst&q=UPDLOCK&rnum=2#a242e4eeb2ae00fd Before I go any further, let me mentions that this is 2005. I'm trying to ...more >>

The table I want to process has the data below (I have added 2 blank rows for illustration): AG00780 2000-01-04 G 194 194 177 177 178 178 220 224 171 175 AG00780 2000-09-07 H 194 194 177 177 178 178 220 224 171 175 AG00780 2004-10-23 H 194 194 177 177 178 178 220 224 171 175 AG01518...more >>

Hi I need help with an query result. There are two tables in my database create table project_dates ( company_name char(40), proj_code char(5), proj_lead char (6), h_count char(1), cost ...more >>

What is the perf mon counter that displays/logs auto growth of the mdf file? The counter for the ldf is obvious under Sql Server Databases:Log File Growth or something similar. But the one for the mdf seems much less obvious or maybe my eagle just keeps missing it......more >>

Hi Tibor. looks like this one didn't reach the group yesterday. Done all that .. it does seem to be a lock on tempdb..sysindexes.. plus some of the indexes (PK) on @tables. do we have control over this ? thanks "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in...more >>

I need to get many, if not all rows in a database table, update selected fields and save the resuits back to the database. The following works OK for small databases, but does not scale up to large databases void UpdateDatabase() { string sCmd = "SELECT Field1, Field2 FROM Table"; SqlConn...more >>

What is the proper syntax for stacking these IFs in a Stored Procedure??? Thanks in advance... wnfisba IF @Loan_Nbr IS NOT NULL IF @MTM_Losses_Accrued IS NOT NULL IF EXISTS ( SELECT 1 FROM [DMD_Data]..[UDF_WARRANTY] WARRANTY...more >>

Hi I had a SQL Server 2000 database by name Jap.Recently my c drive crashed and i have only jap_data and jap_log files stored in D drive.Can i restore back these files so that i will be able to use them?I had few critical office data and would appreciate a quick help in this regard My Best A...more >>

This is driving me crazy. I've got a 2000 SP4 server with intermittant timeouts. For example, this morning at 8:24 am, about five processes timed out. I checked Perf Mon and everything looks great: disk i/o was low, processor was reasonable, buffer cache was 100, paging was minimal, page l...more >>

Hi, I have a stored proc that calls multiple stored procedures. i need the entire process to be under a transaction so let's say that stored procedure #4 fails, the entire transaction in SP1, SP2, SP3 needs to be rolled back. Any ideas? RC ...more >>

I have searched high and low and cannot find a working example of using OPENROWSET to connect to an access datasoure WHILE using a system database. I have seen lots of examples where the system database property is ommited, but I need to connect to a database specifying the system database so...more >>

I have a ProperCase function that works well. However, I'm constantly adding "exceptions" into the funciton. For example, I want IPA uppercase, but not when it's in constIPAtion. This got me to thinking that it might be easier to add all my cases into a table, rather than constantly editing...more >>

Are there any rules for when not to use a transaction? I have one process writing to a database and another process reading from that database. The writes aren't like the classic case of a bank transfer .... I wouldn't be looking to rollback a group of transactions. In this circumstance is...more >>

I wrote the following query to update two tables ++++++++++++++++++++++++++++++++++++++++++++++++ DECLARE @myid nchar(128) Declare @userid uniqueidentifier Set @userID=newid() Set @myid='83e79498-fbd0-43ae-9d07-f6a7383b09a7' INSERT INTO dbo.aspnet_users (ApplicationID, UserID, Username, L...more >>

Hi Friends, I need to know what is wrong on this example below from BOL SQL 2005, ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/02c1bc0b-760c-4589-9ab1-6927c6d9c734.htm. Topic "G. Querying xml type columns": USE AdventureWorks; GO SELECT ProductModelID, Name, Instructions.query(' d...more >>

Can you kind folks tell me what I"m doing wrong to get this error when trying to use DATEADD ? CREATE function dbo.TimeBuffer ( @obs varchar(255), @myName varchar(255), @obsDateTime datetime, @dateTimeInterval int ) returns table as return ( select o.* from Ti...more >>

Hi all, I am writing a stored procedure into which I will supply a parameter. This sp will then perform a query on a table and will always return exactly one record. One or more of the columns in this record have a value and the rest will be nulls e.g. Col1 Col2 Col3 Col4 Col5 1 ...more >>

I am attempting to export a binary file from my SQL Server 2005 database to a .jpg file. Below are the import and export routines I am using. All is well, except that there appears to be four bytes added to the exported file causing the OS to not recognize the file format. Looking at the file...more >>

I am getting the following error: Microsoft OLE DB Provider for SQL Server (0x80040E21) The requested properties cannot be supported. >From a new DB that was created. This doenst happen with an existing DB.... does anyone have any advise that will help me out? ...more >>

Hi I'm new to SQL and am having trouble figuring this one out. Any help would be very much appreciated. I have 2 tables 'A_Totals' & 'B_Totals' each table is identical in construction, each column is labeled Date,Total1,Total2,Total3 up to Total 18. I have written some sctipts that popul...more >>

What is the meaning of Temporary Index? When must I make it? How to make it? Will it be created automatically when i use "Order By" clause? I use sql server 2000 ...more >>

Hello, I'm having trouble creating a backup script to save all the databases in the database server. I have the following script but can't figure out how to get this to execute. As you can tell, I'm not a skilled T-SQL guy, nor a DBA. I'd like to create a single file for each db with n...more >>

Hi, I constantly export client SQL server tables to files of different formats as above. Is there a way of dynamically doing this? given a file path, table name and format type as parameters? perhaps via a stored procedure or SSIS ? Could XML be useful? Any pointers will be most appreci...more >>

Hi, I need to update a Table which will be having around two million data, like if Name is null then store "Name" & if Address is null then store "Address" like 15 columns. Which way would be better among these? 1 ) Open a cursor with all the data in the table, then select one row at a ...more >>

Hi, This is with respect to symmetric cryptography. We want to encrypt a column data using symmetric cryptographic algorithms at SQL server 2000 side and this encrypted data would be accessed by other application (AS 400) which should get the data in decrypted form. So the need is that both...more >>

Anyone know if there is any shortcut (shortkey) to do so instead of going to Tools-->QueryAnalyzer? ...more >>

I am sorting varchar data on binary (ascii sort) . declare @a table (filenames varchar(50)) insert into @a values ('000abcd.asp') insert into @a values ('000ABCD.ASP') insert into @a values ('0001Pqrs.asp') insert into @a values ('000xyz.ASP') select * from @a order by cast(upper(f...more >>

hi veryone. i want to create function in sql server to do exactly same thing as following vb function does SplitIp = Split(input,".") SmallIp=SplitIp(0)&"."&SplitIp(1)&"."&SplitIp(2) basicly i want to get just first 3 parts of ip address and i am noob can some one help me? thanks ...more >>

Hello I'm having problems with modifying a view, I have SUM(OD.Quantity * OD.UnitPrice) OVER (PARTITION BY OD.OrderId) as one resultcolumn, and I get his error when I try to modify the view. "The OVER SQL construct or statement is not supported.", so I try to modify it anyways and I get same ...more >>

there is an error ( [ line 11, near '(' ] - full join line ) when check syntax. i do not know what is the error, even i can run it at QA after replacing some variables, such as @Date1, @Date2 Thanks a lot. ************************* CREATE PROCEDURE dbo.MonthlyBreakdown @Date0 varch...more >>