Viewing 15 posts - 31 through 45 (of 57 total)
I am sorry for all my spelling mistakes from before the script 🙂
June 26, 2003 at 1:36 pm
what id soes:
creates a table in another database, le't say Security with the name of the user attached of the Rights_ prefix...
Then runs.
PLease read and ADAPT ...
June 26, 2003 at 1:34 pm
I just created some interesting SP that gets as argument the role or user login and returns ALL permissions for that role/user into a table
It is in testing...
June 26, 2003 at 11:53 am
Thank you for all
but the coolest one is the SQL log script
🙂
June 13, 2003 at 2:21 pm
personally I did not find it useful
here is some script that uses a table withg 13 million rows:
SELECT top 1000000 * from sku
/* ...
June 12, 2003 at 10:41 am
I would add - just this:
in DTS (at the end) run a store proc. that takes the unique fields from StagingData table and puts...
June 8, 2003 at 9:47 pm
I would appreciate if you publish the small conversion.
Sounds interesting
Thank you
ps. we just have an issue with an image database and I would like to check this...
June 8, 2003 at 9:33 pm
Thank you;It was good.I whish I know more!
Can we do the next one with the tuning topic 🙂
June 6, 2003 at 1:30 pm
what I do if I want to clean:
- change name of SP,table,view with "delete_" string in front- after you are SURE you have talked this thru
- ...
June 3, 2003 at 8:00 am
please do not use temp tables.They are not efficient and you must clean the tempdb after use.Especially if you use global temp tables.
Better use a...
June 2, 2003 at 2:12 pm
I would have a different type of experience.
I have 4 possibilities
1 cursor
2 temp table created with "into" statement with no...
May 29, 2003 at 1:20 pm
- if you use temporary tables for your SQL or SP, if those temp tables are indexed and you have to manipulate large amouns of data
-...
May 29, 2003 at 10:42 am
Viewing 15 posts - 31 through 45 (of 57 total)