Viewing 15 posts - 37,141 through 37,155 (of 39,461 total)
I use:
dfZero - 0
dfOne - 1
others as needed (I have neede dfThree)
dfBlank - space(1)
dfGetDate - getdate()
dfGUID - newid()
Sequential - use identity or UDF
Random - use a UDF, will get better...
July 10, 2002 at 10:04 am
I think Brian has the best suggestions.
Though I would leave the BuiltIn/Adminstrators in there. Nice to have a second way in, just in case.
Steve Jones
July 10, 2002 at 10:00 am
DBCC is your only real check. It sounds like you have data integrity issues, which are different than corruption. Can you search all the tables affected to be sure there...
July 10, 2002 at 9:59 am
You are welcome. Glad I could help.
Steve Jones
July 10, 2002 at 9:57 am
I agree with brian, but if you ahve access to sniff. With today's switches being deployed in so many places, it can be difficult for someone in your org or...
July 10, 2002 at 9:53 am
For 10 extents, this cannot be a big deal. I wouldn't really be concerned unless I had over 100 extents.
Brian has good advice.
Steve Jones
July 10, 2002 at 9:51 am
If you get this, pls post it. We have mostly standard, but a few different ones and this would be nice.
Steve Jones
July 10, 2002 at 9:42 am
This isn't a linked server issue from the sound of it, but a data or other client side issue (or server side i guess).
A couple other things (besides those listed...
July 10, 2002 at 9:30 am
You could query information_shema views and roll your own script.
Steve Jones
July 9, 2002 at 12:51 pm
Check that he is not the member of some role that has access denied.
Also be sure the delete trigger is not preventing this.
Are there error messages?
Steve Jones
July 9, 2002 at 12:48 pm
You could use DTS to either alter the package (hard) or generate a filename and rename the generated one (easier).
Look for the filesystemobject on MSDN and that will point you...
July 9, 2002 at 9:40 am
Ran this on SQL 2000
declare @i char(3)
select @i = 'ZZZ'
select @i
select @i = rack
from racks
where 1 = 0
select @i
I still get 'ZZZ' both selects. I suspect your data...
July 9, 2002 at 9:29 am
50000 and above are reserved for user defined errors.
If you can post more info, we might be able to help.
Steve Jones
July 9, 2002 at 9:27 am
Viewing 15 posts - 37,141 through 37,155 (of 39,461 total)