Viewing 15 posts - 1 through 15 (of 57 total)
primary = F,G,I
order = G
April 21, 2004 at 10:39 am
April 21, 2004 at 10:31 am
Is the internal SP under a different owner name?
If yes, add owner_name.youre internal_SP
April 20, 2004 at 12:40 pm
sp_dboption [ [ @dbname = ] 'database' ]
[ , [ @optname = ] 'option_name' ]
[ , [ @optvalue = ] 'value' ]
April 19, 2004 at 12:44 pm
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
April 19, 2004 at 12:20 pm
The best after me integer
cast(convert(char(20),your_date_column_name,112) as int)
It can be easily controlled and is faster, much faster that any date or varchar datatype
April 19, 2004 at 11:24 am
Thanks for the article.
What buggs me is the public role ijn Master db
because it has powers against information_schema objects
Could we get rid of those permissons with no further negative effects?
December 12, 2003 at 9:55 am
December 8, 2003 at 12:20 pm
that is a good idea.
The only think that I would do ..instead to recover in the same PC I would recover in different one because the memory and CPU...
November 14, 2003 at 1:30 pm
how you do your backup - on backup devices?
- what type of backup?
try and run DBCC CHECKFILE(file_name)
November 5, 2003 at 10:32 am
jeffwe you are right.But I think that is the closest.
What I did is to create datafiles and move my tables - wrote a note with where the tables...
November 5, 2003 at 10:30 am
Thanks a million.
I did now to use "indid"...that answered my question
You have no idea how much headache solves me!
November 4, 2003 at 12:52 pm
how many times /week/day you load the data?
If 1,2,3/week change the option model for the database to Bulk-Logged
and make sure you do a backup log after...
October 31, 2003 at 8:58 am
and no error message at the PC app level or system level...wierd!
October 29, 2003 at 1:54 pm
sorry for my late reply.
I restored into a different PC and even when I reproduced the tempdb error I did not get the 823 err.
October 29, 2003 at 1:53 pm