Search results for query: *

I got it working, I chaged the default database for SA

Great, this worked... I couldn't find the osql piece. Everywhere I looked to sqlcmd. So my next problem is when I log into SQL Enterprise Manager it uses windows authentication....how do I change the default for that?

Hello- I have a Sql server 8.0 database which the default database has been deleted. I need to figure out how to change the default database so I can connect and repair everything. I have seen information all over the place for more recent versions of SQL Server but not 8.0. Thank you in advance

Dagon- You are correct, what I was planning to do with my SQL was to build a table with date ranges. I would have had a "where device id is not null" clause in there. Im currently trying to figure out how big of a problem this is. Thanks for the nudge towards the right direction.

I have a table with 1.2 billion rows. This table tracks a users transaction and which device it used to complete the transaction. Not all transactions give us the device id so we are trying to fill in the gaps with the correct device id by building a tables which has date ranges that each...

So it looks like it was the declaration of variable that was causing me an issue. When it was suggested that I put in a length, I had a space in between the variable and the length. When I removed the space. Everything worked. Thanks for all the help.

I have tried to run it 3 ways. 1. maint_rows 'C1264' 2. execute maint_rows 'C1264' 3. Declare @RC int Declare @id varchar(50) SELECT 2id = '''C1264''' EXEC 2rc = [proddb].[dbo].[maint_rows] @id DECLARE @prnline nvarchar(4000) print 'Stored Procedure: proddb.dbo.maint_rows' select @prnline =...

Thanks but that wasn't it. I also tried remove the declaration of the transaction and that didnt help either.

Ok, Oracle guy here looking for some help. I have a proc that I wrote to clean up some data. ALTER PROC maint_rows @id varchar AS BEGIN BEGIN TRAN delete maint_table where entityid = @id COMMIT TRAN END This compiles and runs but after it completes, the record is still there...

Thanks so much for the help. I knew it was something simple but I am not an Access guy or VB. Basically what happened was about 5 called sub routines deep, there was a column for city which was set to 20 characters. Well Hot Springs National Park didn't fit. THANKS AGAIN....BIG STAR FOR YOU!

Forget that last statement, It sets the batchdate back to null on the exception handling. Sorry for the confusion.

One more thing to add. I know its not updating two tables in SQL Server that it is hitting in the above code, so the error is happening before that.

Thanks, thats going to be a big help now that I know I cant do that All it says though is: Resume Exit_LoadDailyProcessing The exit_loaddailyprocessing is like so: Exit_LoadDailyProcessing: If Interim Then PaymentConn.Execute "Update AutoPay Set BatchDate = Null Where BatchDate =...

I am looking at an old Access App and am way in over my head I am getting the error The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. When I look at the module I see there is a report trying to open which calls a query. When I try to...

I have a Gupta/Team Developer application that fell into my lap. I am looking for training or tutorials that may help me get up to speed. Does anyone have any suggestions?

I have a partitioned table with about 500 million rows. We need to add am artificial key to the table. What would you think would be the fastest way? I know I can just do it in a cursor but I would think that would take forever. Any suggestions?

Exactly! You the man, thanks a ton!

Quick question for you crystal experts. (I am a database guy, not a Crystal guy) I am using Crystal 8.5 to generate a letter to my customers. I am getting the data from a SQL Server procedure. When I run the procedure, it returns 7 rows. The crystal report only generates to letters. I also...

Yes, thank you. That is exactly the explanation I was looking for.

Yes Dave but why!?!?!? I dont get it. Long time no see Dave, I was just thinking about you and your story about setting the garage on fire when you were a kid. Good times