Viewing 15 posts - 38,896 through 38,910 (of 39,803 total)
I've done this quite a bit. There should not be a mapping for the field on the transformations tab.
Also, a PK in SQL Server deos not necessarily mean an auto-generated...
December 21, 2001 at 9:41 am
Not that I know of. I think you would have to remove all references to this before you can change it.
Alternatively, you can create a new datatype and move all...
December 21, 2001 at 8:53 am
The cache clears it self of unused procedures over time.
You should only do this for testing.
Steve Jones
December 20, 2001 at 12:32 pm
There are a few articles on removing admins from SQL. Not too bad in SS2K.
I was more referring to restricting admins on the network,not SQL.
Steve Jones
December 20, 2001 at 12:32 pm
like
select *
from a
inner join b
on a.id = b.id
inner join c
on b.otherid...
December 20, 2001 at 10:10 am
December 20, 2001 at 10:08 am
December 20, 2001 at 10:06 am
December 20, 2001 at 10:02 am
Works on local SQL2K Personal, 2 SQL 2K Server SP1, and on SQL 7, SP2 boxes.
Steve Jones
December 19, 2001 at 5:35 pm
Flag should never be cleared. I control the source, so this as good as it gets. If the flag gets cleared by someone, they'll be explaining to the CTO and...
December 19, 2001 at 2:35 pm
Interesting. I have to admin I have no experience, but I would think that EMC could provide some guidence. I interviewed with a company that had an EMC array on...
December 19, 2001 at 2:33 pm
That's funny (also not). I've used a couple hosting companies and DataReturn did it the right way. They ran a procedure to backup to disk and then grabbed these to...
December 19, 2001 at 2:30 pm
Even easier. look over the article. For special cases, you will need to build a case statement to handle each.
Steve Jones
December 19, 2001 at 11:46 am
December 19, 2001 at 11:24 am
December 19, 2001 at 11:24 am
Viewing 15 posts - 38,896 through 38,910 (of 39,803 total)