Post 2/2 And the other issue: If I want to do a LogRestore after this FullRestore method, I do something like this in my main method: DoFulLRestore(currentRequest, false) where false indicates the FinalStep value, indicating that there is a log restore being followed, so the .NoRecove...more >>

Hello all, I'm having some issues with restoring databases through SMO in a vb.net application. The restores always happen from the same SQL version, so 2000 -> 2000, 2005 -> 2005. There are two issues I just can't seem to get fixed... The code shown below is written to function with a cen...more >>

I have solved this problem like this: My procedure was having hearder comments as follows. /*=================================================== Author : Muralikrishna Reddy Create date : 01-Sept-2007 Description : /* sdfsdff sdfsdf sdfsdfsd */ =====================...more >>

This problem could be caused by the task that reads the file (your dataflow) may be starting before the entire 2GB file has been written. There may be an entry in the directory for it, which would trigger a WMI watch task for instance, but until the entire file is written, an attempt to open it woul...more >>

When trying to generate a model, I get the following message "ParentKey and ChildKey are identical" There are currently 120 tables in my database. How can I identify which table(s) have identical parent and child keys? From http://www.developmentnow.com/g/113_2007_11_0_0_0/sql-server-programming.ht...more >>

hi. is there a way to pass columns as parameters to a function? (for mssql 2000 server) my query is something like that: select tb1.* from tb1 inner join tb2 on tb1.c2=tb2.c1 where tb1.c1 in ( select * from dbo.fn_Split(tb2.c2,',') ) error: c2 is not recognized OPTIMIZER LOCK HINTS ...more >>

Try adding 1 day to @EndDate. WHEN using between and puting in a date '1/18/2008' for example, sql server assumes '1/18/2008 12:00:00 AM' when performing a comparrision. From http://www.developmentnow.com/g/113_2003_7_0_0_411955/Date-Time.htm Posted via DevelopmentNow.com Groups http://www.develop...more >>

@Jasper @Sky Fly Thanks men! I've found a table named with a single quote that was causing the error on ITW! Almost 4 years later and MS hasn't fixed the bug. Best Regards! Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is Se...more >>

I'm working on a web-based app where my database is using SQL Server. I have two columns which I need to set it to case-sensitive, such as password and code. I read some articles and found collation. Is that the right one? But I'm not sure how to use them, can anyone please help me? Than...more >>

Aaron wrote: "sysjobhistory will have run_status = 0 AND [message] LIKE 'The job failed.%' where step_id = 0 and job_id = x." Does run_status correlate with the return code of sp_help_jobactivity? If so, then run_status = 0 indicates success. Is there a query I can run that will give a num...more >>

Hello, friends, We are using C#.net and SQL Server 2000, and using stored procedures to retrieve records. However, with a new feature we are developing now, we need to sort the records based on user's selections. So, the Order By clause will be dynamic. Is there a way that a stored proce...more >>

> I mean I want to sum a column with previous column.. > how can I do that? One method to calculate a running total is with a subquery: CREATE TABLE dbo.MyTable ( [Code] int NOT NULL CONSTRAINT PK_MyTable PRIMARY KEY, [Value] int NOT NULL ) INSERT INTO dbo.MyTable SEL...more >>

> Is > there a way in the where clause to define it so the where clause can take > a > parameter what ever its value and for the null not restrict the search. One method is to use COALESCE: WHERE [date]=COALESCE(@DateTimeParameter, [date]) For a more thorough discussion of this and othe...more >>

Well said. Often the 'real world'... you know, the one where people pay you money to implement their ideas... dictates how things will look. Often it is not pretty, often it is not efficient from the purist's sense. But it works and it deals with the real world in ways they are familiar. ...more >>

CLM, I think you are looking at this the wrong way. Cursors are not 'bad' at all... at least no less useful than any tool used for the job in which they were intended. Indexes are 'bad' if you have too many. Normalisation is 'bad' if you over do it. Cursors have an important place in cre...more >>

I want to search on the max date in db based on an input date and use that to find foreign key on that field to search another table. Select max(version_id) from T1 where date<@date1 select * from T2 where T2.version=max(version_id) I am working in Sql 2000 and want to be able to use a ...more >>

I have parameters to a stored procedure that may be null or have a value. In the case of a null value the search is not to be using that parameter. Is there a way in the where clause to define it so the where clause can take a parameter what ever its value and for the null not restrict the s...more >>

Hello, Is there a way to tell SQL to take e.g. '2,500.50' string and convert implicitly it to decimal? The column type is decimal (19,5). If I have columns of type 'money' it does that conversion with no problem. Or if there is a way to change precision of 'money' type? thanks ...more >>

I have table: ItemId, ItemName, ParentId, FullPath eg: 1, null, first, first 2, 1, second, first/second 3,2, third, third/second .... and so on, no limit for depth now, when i update name of "item", i need to update FullPath of all "item" 's children How to do it? Recursion, trigg...more >>

thanks. "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message news:D79D683A-235C-45EB-934C-7AECB4F2AFE6@microsoft.com... >> I mean I want to sum a column with previous column.. >> how can I do that? > > One method to calculate a running total is with a subquery: > > CREATE ...more >>

Hi all I have a table like this Code Value 1 1000 2 2000 3 -500 I want to write a query that returns like following output: Code Value Total 1 1000 1000 2 2000 3000 3 -500 2500 I mean I want to sum a colum...more >>

Jeff Swanberg (j_swanberg@msn.com) writes: > This only works in Query Analyzer, though, if I go to > Tools-Options-Results and change the "Maximum characters per column" > value to 7000. If I don't, then the only value that gets put into > TableA's ATTENDANCE column is the first 256 characters ...more >>

/* on cursors: Say you had 5 million customer OLTP environment that was operational 24/7, you had just received a data clensing update for postcode/address correction. How would you update your customer database with the new addresses ? Although a set based approach would work, You might ...more >>

CLM (CLM@discussions.microsoft.com) writes: > I just read something surprising in my 2005 cert study materials: Sql > Server cannot generate an execution plan for a cursor. Is that really > true? I knew cursors were a bad idea, because they're not set-based, > etc., but I didn't realize that ...more >>

On Thu, 01 Nov 2007 23:37:51 -0700, pradeep kumar wrote: >hello, >sir, >i am pradeep kumar. i am make a long project of fee management then use a "insert query" with two table on particular row with where condition then not run this query. error is invaild "where" keyword please give me anwser ...more >>

On Thu, 1 Nov 2007 17:36:01 -0700, RBC wrote: >Dear to Whom this Concern, > >Could some one learn me how I could update my table field via stored >procedure? Hi Rune, UPDATE MyTable SET MyColumn = @NewValue WHERE KeyColumn = @KeyValue; >I have a stored procedure that generates ...more >>

On Fri, 02 Nov 2007 10:23:55 -0700, --CELKO-- wrote: >>> I have to ask, if the natural key crowd don't have answers to these questions, why do they still use them? << > >Validation and verification. Consider a VIN on your automobile. No >matter where I go on the entire planet, it identifies ...more >>

On Fri, 02 Nov 2007 10:38:13 -0700, --CELKO-- wrote: >>> For implementation, I prefer using identities for surrogates - they're solid (as long as the column is constrained to be unique), they're efficient, and they generate quickly (I don't have to roll my own). << > >Solid?? You are being loca...more >>

On Fri, 2 Nov 2007 21:15:31 +1100, Michael C wrote: >"Michael C" <mike@nospam.com> wrote in message >news:%23tomOr2GIHA.2328@TK2MSFTNGP03.phx.gbl... >> "Q7: I would like to change my user name, how can I do it? >> A: Unfortunately, it is not possible due to technical reasons (because of >> ...more >>