Viewing 15 posts - 181 through 195 (of 345 total)
Nothing run from the scheduler can have user interaction as it doen't have a display associated.
You could have the app put things into a table and query that.
Cursors never.
DTS -...
October 31, 2003 at 10:14 pm
Is it the same databases that always change back to simple?
Run a job to log the recovery model of all databases every few minutes so yo can find out when...
October 31, 2003 at 9:12 pm
You can create and populate a temp table then access it from within the SP.
Cursors never.
DTS - only when needed and never to control.
October 31, 2003 at 4:39 am
see dbcc log (dbname,4)
or try the log explorer from lumigent.
Cursors never.
DTS - only when needed and never to control.
October 31, 2003 at 4:37 am
Are you taking log backups? If not then you should set the recovery model to simple for the database.
I would also recommend changing the recovery model for the model database...
October 31, 2003 at 1:17 am
Get a copy of
Inside sql server 2000 by Kalen Delaney.
It tells you a lot about the internal structures in sql server.
Cursors never.
DTS - only when needed and never to...
October 30, 2003 at 11:29 pm
Easiest is probably to create a linked server - see security in enterprise manager or sp_addlinkedserever in bol. Then you can query it using the 4 part name as you...
October 30, 2003 at 11:27 pm
select *
from tbl t1
where grade = (select max(t2.grade) from tbl t2 where t1.student = t2.student)
If it is possible to have multiple recs for a student with the same highest grade...
October 30, 2003 at 8:12 pm
Don't know db2 but try setting the source as a query and converting the datetimes to
yyyymmdd hh:mm:ss
Cursors never.
DTS - only when needed and never to control.
October 30, 2003 at 8:09 pm
You would have to try it and see.
You could also try splittimg the table up and accessing through a partitioned view.
Depends how it is used but for something this large...
October 5, 2003 at 11:33 pm
In a union the columns returned must contain data of a single datatype. This will be decided by the first statement in the union.
If the server cannot implicitely convert all...
July 7, 2003 at 9:25 pm
Doesn't help if you want the developers to own their SPs during development and only change the owner later though.
Cursors never.
DTS - only when needed and never to control.
March 19, 2003 at 6:02 am
Why not
create table
(
type varchar(1),
i int
}
where type = a,b,c.
Cursors never.
DTS - only when needed and never to control.
March 18, 2003 at 3:56 pm
>> there some rule that does not allow the datatype Text to be use as a variable datatype in a stored procedure?
Yes.
I can declare my variable as a larger varchar...
March 17, 2003 at 10:49 pm
You can create a global temp table from inserted.
select * into ##inserted from inserted then use that for the bcp.
You can stop anothyer process from doing the same thijng by...
March 17, 2003 at 8:21 pm
Viewing 15 posts - 181 through 195 (of 345 total)